http://sqle.ru/index.php?action=history&feed=atom&title=MySQL_Tutorial%2FMySQL_Utilities%2FmysqldumpMySQL Tutorial/MySQL Utilities/mysqldump - История изменений2026-04-04T02:11:49ZИстория изменений этой страницы в викиMediaWiki 1.30.0http://sqle.ru/index.php?title=MySQL_Tutorial/MySQL_Utilities/mysqldump&diff=17&oldid=prev в 13:44, 26 мая 20102010-05-26T13:44:56Z<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:44, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>http://sqle.ru/index.php?title=MySQL_Tutorial/MySQL_Utilities/mysqldump&diff=18&oldid=prevAdmin: 1 версия2010-05-26T09:49:07Z<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Automatically drop any tables that exist before restoring the stored tables with the " --add-drop-table "==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
c:\mysql\bin\mysqldump -u root -p --add-drop-table myDatabase > myDatabase.sql</source><br />
<br />
<br />
<br />
== Create the database if it doesn"t already exist with "--databases" option to specify the database we wish to back up==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
c:\mysql\bin\mysqldump -u root -p --databases myDatabase > myDatabase.sql</source><br />
<br />
<br />
<br />
== mysqldump==<br />
<br />
<p>mysqldump outputs the table structure and data in series of SQL commands stored in a text file.</p><br />
<p>The simplified syntax is</p><br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
c:\mysql\bin\mysqldump -u <username> -p <database> [<table>] > file.sql</source><br />
<br />
<br />
<br />
== Optimising a dump==<br />
<br />
<p>"--opt" is used override the mysql server"s normal method of reading the whole result set into memory giving a faster dump.</p><br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
c:\mysql\bin\mysqldump -u root -p --opt myDatabase > myDatabase.sql</source><br />
<br />
<br />
<br />
== Restoring a Dump==<br />
<br />
<p>Restoring a dump depends on what you have actually dumped.</p><br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
c:\mysql\bin\mysql -u root -p myDatabase < myDatabase.sql</source><br />
<br />
<br />
<br />
== To make a copy of live data==<br />
<br />
<p>To do this you would need to duplicate a local database.</p><br />
<p>First create the duplicate database:</p><br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
mysql> CREATE DATABASE myDatabase2;</source><br />
<br />
<br />
<br />
== Using mysqldump to copy databases==<br />
<br />
<p>It is possible to combine a dump and a restore on one line by using a pipe "|" to pass the output of the dump directly to mysql basically bypassing the file.</p><br />
<p>We can use this method to copy a database to another server or even create a duplicate copy.</p><br />
<p>For example to copy the "myDatabase" database to a mysql server called "remote.server.ru":</p><br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
c:\mysql\bin\mysqldump -u root -p --databases myDatabase | \<br />
> mysql -u backup -p MyPassword -h remote.server.ru</source><br />
<br />
<br />
<p>The "\" at the end of the first line means you wish to contine the command on another line before executing it.</p></div>Admin