Backup of database.

I want to move host and I need a copy/backup of my database. There is no cPanel or phpmyadmin. How can I make a backup ? My host says that I can use mysqldump from my own machine. I have no idea of what that is.

 

try this command and it will backup everything as wished:

# mysqldump --opt -u username --password=yourpasswd databasename > /pathtoyourfile/yourbackupfile.sql

now you can upload the sql file to your new host and do this:
mysql> source /pathtoyourfile/yourbackupfile.sql


And if you have a large database, you better use the mysqldump command with compression option (check out the mysql website for some doc.)

 

Thanks, but I am totally blank on this, where do I put this command ? and will I get a back up on my computer then ?

# mysqldump --opt -u username --password=yourpasswd databasename > /pathtoyourfile/yourbackupfile.sql

 

you issue the command from the command line of your server
it will output the file inside 'yourbackupfile.sql' and inside the 'pathtoyourfile' directory.

 

Just upload phpMyAdmin there. It you have FTP access you can just upload phpMyAdmin and use it.

 

Ok thanks, I solved it, found out that wordpress has a database backup plug-in.

 

Create a full backup of your database:

shell> mysqldump --tab=/path/to/some/dir --opt db_name

Or:

shell> mysqlhotcopy db_name /path/to/some/dir.
For more info go to http://dev.mysql.com/doc/refman/5.0/en/backup.html