Thread: Backing up your database from the command line

To backup your database from the command line, use the following commands:

Code:

mysqldump -u username -p aedating > aedating.sql

username = your database username
aedating = your aedating database name

When you run the command, it will ask you for your password, perform the export, and then exit. You will then find the new sql file in the directory you ran the command from.

Hi all,

When using the mysql dump, you need to use the -Q option because there is at least one table that uses a MySQL reserved word for a field name (GLParams has a description field named 'desc'). This option forces the SQL statements to have quoted table and field names. If you do not do this, you will receive a SQL syntax error when you try to import from the dump file.

rock on,

Hi@all

use for backup this command:

mysqldump -a -c -e -Q databasename -u username -p > aedating.sql

from backup:

mysql -p -D databasename < aedating.sql

best regards

Nachtstern, I followed your instructions above and I was able to download and upload my tables without the problems I initially had. You're a lifesaver. Thanks.

Hi

i am glad to help you

best regards

Is there any way to do this if a dump was not performed? For example, if there was a system failure and server had to be reimaged, but the old data files are still present.

What files would I copy?

How many times are you guys taking a backup? Is it only an SQLDump or also folders like id_img/wav/video?

Are you using a third party software like SQLyog,navicat,...?

just curious

use WHM.

It backs up all my files (as a tar.gz) and dumps the database

One copy is saved to my server hard drive.

One copy goes to Smoge's server, by sftp.

I have a daily, a weekly, and a monthly.

Slim

I tried to put

mysqldump -a -c -e -Q databasename -u username -p > aedating.sql

in the command line (cronjobs) but I always get that error:

enter password: mysqldump: Got error: 1045: Access denied for user: 'username@localhost' (Using password: NO) when trying to connect

How to make this cronjob work?

Originally Posted by raeyo

mysqldump -a -c -e -Q databasename -u username -p > aedating.sql

Hi,

You need to put where it says databasename, the name of your database on your system, and where it says username, a mySQL user on your system that has rights to access that database.

Smoge