How to Create a File Dump from a MySQL Database

Picture of Mertech Mertech : Feb 24, 2008 3:45:00 PM

Databases

Create the Dump File:

mysqldump --user=&lt;user&gt; --password=&lt;password&gt; &lt;database&gt; --result-file=&lt;file.sql&gt;

Load the Dump File:

myql --user=<user> --password=<password>
use <database>
source <file.sql>

Create a Dump With Only CREATE Commands:

To create a dump in MySQL without the DROP commands or any other extra command, use this syntax:

mysqldump -u user -p --skip-opt database &gt; dump.sql

External References:

http://www.howtoforge.com/back_up_mysql_dbs_without_interruptions (This is a script I have been using myself, also note down that site IF you are not familiar with it and care about linux).

Why Migrate from Btrieve to PostgreSQL and other Relational Databases?

Riaz Merchant: Oct 28, 2024 6:12:41 AM

Introduction Many independent software vendors (ISV) and corporate users still rely on applications that use a category of database collective called...