Dismiss Notice
Welcome to Our Community
Wanting to join the rest of our members? Feel free to sign up today.

Help: phpMyAdmin Not Working

Discussion in 'Blogging' started by deluxdon, Dec 4, 2009.

  1. deluxdon

    deluxdon New Member Webmaster

    Install WP DB Backup plugin and take regularly backup using it.

  2. smilly123

    smilly123 New Member Webmaster

    There are many ways to take a database backup using phpMyAdmin - but my favorite way is to take an SQL Dump. Select the database you want to backup and click 'Export' tab in the main frame. Now select all the tables in the select box. You can select the format of the backup - like SQL, CSV, XML etc. We will select the SQL option. It is recommended that you check the 'Add DROP TABLE' and 'Add IF NOT EXISTS' checkboxs. This will make sure that the existing tables will be removed when restoring the backup. Now check the 'Save as file' checkbox. Then click the 'Go' button. Now you should see a download option for the database backup. You can save this file to you harddisk and run it later if you want to restore the backup. If you did not check the 'Save as file' option, the SQL dump will be shown in a textarea.
    This can also be done using the 'mysqldump' command in linux using the following command.
  3. JennyRipley

    JennyRipley New Member Webmaster

    I agree with you smilly123,if you have cpanel you can do it easily.

Featured Resources (View All)

Share This Page