<div>
Use<br />

<pre><code id="code-20-39890468-1">cat &lt;old.sql&gt; | sed -e 's/&lt;this&gt;/&lt;that&gt;/' &gt; &lt;new.sql&gt;</code></pre>
<br />
be sure to check your regex in the <i>sed</i> command to properly format for you,<br />
and the check to make sure new.sql is in the format you want.
</div>


Use


cat <old.sql> | sed -e 's/<this>/<that>/' > <new.sql>


be sure to check your regex in the sed command to properly format for you,
and the check to make sure new.sql is in the format you want.

<div>
Can I directly pass this to mysql to load data ?<br />
<br />
&nbsp;mysql -p123 -uthesecondary thesecondary &lt;&nbsp;cat &lt;old.sql&gt; | sed -e 's/&lt;this&gt;/&lt;that&gt;/'
</div>


Can I directly pass this to mysql to load data ?

 mysql -p123 -uthesecondary thesecondary < cat <old.sql> | sed -e 's/<this>/<that>/'

<div>
yes you can, but I'll advice you check first. of course once you've checked and it does what you want, why not.
</div>


yes you can, but I'll advice you check first. of course once you've checked and it does what you want, why not.

<div>
<div class="content wysiwyg-content">
Hi,<br />
I have database called primary with 400 mysql tables, some triggers.<br />
<br />
In theory I should able to carry mysqldump export and then use mysql to import it. And it works partially.<br />
<br />
I found problem with triggers, functions . They are tagged as primary database &nbsp;and while compilation it fails as I am compiling it on another database.<br />
<br />
For exa<br />
&nbsp;mysql -p123 -utheprimary &nbsp;thesecondary &lt;&nbsp;theprimary_bkup - Worked <br />
<br />
But I had to carry within vi <br />
%s/theprimary/thesecondary<wbr />/g<br />
<br />
I need to automate this task thru bash script. I think awk/sed should do the trick. <br />
<br />
Thanks
</div>
</div>


Hi,
I have database called primary with 400 mysql tables, some triggers.

In theory I should able to carry mysqldump export and then use mysql to import it. And it works partially.

I found problem with triggers, functions . They are tagged as primary database  and while compilation it fails as I am compiling it on another database.

For exa
 mysql -p123 -utheprimary  thesecondary < theprimary_bkup - Worked 

But I had to carry within vi 
%s/theprimary/thesecondary/g

I need to automate this task thru bash script. I think awk/sed should do the trick. 

Thanks

mysql - copy database from one place to another (awk/sed)

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.