[SOLVED] Mysql table backup

ramecare · 02-15-2012, 02:30 AM

Hi all,

can any one help me how to take mysql table backup from a database

Thank,

jimtony · 02-15-2012, 02:34 AM

See the following documents for your questions.

http://dev.mysql.com/doc/mysql-backu.../en/index.html

ramecare · 02-15-2012, 02:39 AM

The below command is correct to take a mysql table backup and restore

mysqldump dbname tablename > backup.sql
mysql dbname < backup.sql

Thanks,

lithos · 02-15-2012, 03:26 AM

Quote:

Originally Posted by ramecare

The below command is correct to take a mysql table backup and restore

mysqldump dbname tablename > backup.sql
mysql dbname < backup.sql

Thanks,

correct, but probably you will have to set username/password, like:

Code:

mysqldump -u username -ppassword   dbname > dbname_backup.sql

mysql -u username -ppassword  dbname < dbname_backup.sql

! See the -ppassword has no space between -p and password, that's how it works.

good luck

ramecare · 02-15-2012, 03:38 AM

The above command which u mentioned is to take mysql database backup and restore but i want the command to take backup and restore mysql database table

Thanks,

lithos · 02-15-2012, 08:52 AM

I'm sorry, I overlooked that,
I just wanted to point that you probably will need to specify user / password to access that database.

TB0ne · 02-15-2012, 10:36 AM

Quote:

Originally Posted by ramecare

The above command which u mentioned is to take mysql database backup and restore but i want the command to take backup and restore mysql database table

Thanks,

As you've been asked numerous time sin the past, SPELL OUT YOUR WORDS

And did you bother to read the man page on mysqldump, or try to look this up?? From the VERY TOP OF THE MAN PAGE:

Code:

SYNOPSIS
       mysqldump [options] [db_name [tbl_name ...]]

See the part where it tells you to put in the table name?? Try it.

Also, from a brief Google search...
http://www.thegeekstuff.com/2008/09/...ing-mysqldump/
See point 4 for a written example.

ramecare · 02-15-2012, 11:27 AM

Thank u very much

TB0ne · 02-15-2012, 11:47 AM

Quote:

Originally Posted by ramecare

Thank u very much

Seriously?? Again, SPELL OUT YOUR WORDS