Home > MySQL > MySQL – backup details stored procedure all including database

MySQL – backup details stored procedure all including database

To backup the mysql database

No lose all backup, case of migration:
mysqldump –user=root –password=**** –all-databases > /tmp/dnbe_database.sql

Option 1: full database and functions structures but no data
shell> mysqldump –user=root –password=root -R -d db > /tmp/20090201-nodata.sql

Option 2: full database but without cdr, slavecdr table structure and data
shell> mysqldump –user=root –password=root -R –ignore-table=db.cdr –ignore-table=db.slavecdr db > /tmp/20090201-data.sql

Advertisements
Categories: MySQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: