How Can I Backup MySQL Database On Cpanel? - a silly question

I dont know how to backup the database to my computer , in cPanel i click "export" (is that right), but i can't back the file to my computer >.<

Comment/Reply (w/o sign-up)

    Ok.. first of all this method is very very inconvenient. So apply for a SSH Shell in the Hosting Request Forum.

    Once you get SSH Access, download PuTTy - a secure shell terminal from:
a. http://www.chiark.greenend.org.uk/~sgtatha...y/download.html OR
b. http://www.putty.nl/download.html

    Use that to login into your astahost account. Once you are logged in and reach the shell type the following:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-jailshell-2.05b$ mysqldump -u YourUsername -pYourPassword --all-databases > YourBackupFile.sql
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

    Notice the underlined parts above. In the statement above, you should replace YourUsername with you own cPanel username, and YourPassword with the corresponding cPanel password. The YourBackupFile.sql should be replaced with an appropriate name for your backup file. Also notice the fact that when you are specifying your username with the -u option, there IS A SPACE BETWEEN "-u" and your "username" BUT THERE IS NO SPACE BETWEEN "-pYourPassword" i.e. between "-p" and YourPassword.

    Now all you need to do is, download this .sql file onto your local hard drive and run it through MySQL - and you'd have an exact replica of the MySQL database that's residing on your webhost.

NOTE: This will backup ALL the MySQL databases you have into that file. In case you want to backup only a few selected databases, use the "--databases" option followed by the database names instead of "--all-databases". The statement then, would take the form:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-jailshell-2.05b$ mysqldump -u YourUsername -pYourPassword --databases database1 database2 > YourBackupFile.sql
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

    Hope this helps. Believe me, there's not a more convenient way than this to back your MySQL databases up.... Have fun

 

 

 

Comment/Reply (w/o sign-up)

Open phpMyAdmin and use their export feauture. You can have it create an sql file and even compress it.

Comment/Reply (w/o sign-up)

thank you very much , good information for me ^^



I have open phpMyAdmin but i dont know how to export . In the export panel I dont how to export to my computer.... >.<

Comment/Reply (w/o sign-up)

well when you click export in phpMyAdmin it should automatically open a download window.

Comment/Reply (w/o sign-up)

Coder is right, it’s that simple and I have done it more than once. Select backup from your cpanel, and then click on the database you want to backup.

It will give you the option to save the backup as a *.gz file and let you chose where to save it on your computer.

Comment/Reply (w/o sign-up)

hihihihi88: I think you should follow coder2ks advice and use phpMyAdmin to back it up. The method I've mentioned here albeit gives you much more flexibity and control, but is far more compicated and is meant for a little MySQL users. Once you start getting hang of all the MySQL commands and syntaxes - you could try using my method.

Meanwhile I suggest (whether you are running on Linux or Windows) you to grab a copy of MySQL ( http://www.mysql.com ), if you dont have one already - and try out all this on your home computer. That will somewhat familiarize you with the working environment and you'll see light for sure There are lots of good documentation too on their site and a very helpful & dedicated MySQL support forum too - so you won't be left groping in the dark.

All the best

Comment/Reply (w/o sign-up)

phpmyadmin is the way. but don't forget to tick the "export data" option. ortherwise you'll just have your structure (tables).
you'll have an sql file that you can import later on. it's fast & easy.

Comment/Reply (w/o sign-up)