Backup and Restore MySQL Database

  • ladyyen

    (@ladyyen)


    18 years, 9 months ago

    Hi,

    I try to backup and restore MySQL database. i tried follow the methods from these links:

    Backup DB: http://codex.wordpress.org/Backing_Up_Your_Database

    Restore DB: http://codex.wordpress.org/Restoring_Your_Database_From_Backup

    On the restore part, i got this error:

    SQL query:

    — phpMyAdmin SQL Dump
    — version 2.10.0.2
    — http://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Aug 07, 2007 at 09:23 PM
    — Server version: 4.0.27
    — PHP Version: 4.4.4
    SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;

    MySQL said:

    #1193 – Unknown system variable ‘SQL_MODE’

    I tried several times. The error is still the same. Please help. Following are the additional information:

    The PhpMyAdmin version is 2.10.0.2.
    MySQL client version: 4.1.10
    Server version: 4.0.27-standard
    Protocol version: 10

Viewing 2 replies - 1 through 2 (of 2 total)
  • syncbox

    (@syncbox)

    18 years, 9 months ago

    I export the tables for a database to back them up.

    in phpMyadmin, I select my database, click the export tab, “Select All” of the tables (there should be a Select All link below the list of tables), then check the “Save as file” option and choose .sql as the type of file and save to my hard drive.

    With a .sql file, you can open it and make changes if needed, or scan for issues if you know how.

    To restore, I also use phpMyAdmin. I select the database. Then, “Check All” the tables. Select the drop table option in the “with selected” menu and click Go.

    Then, click to the Import tab.

    Browse for your .sql file and import.

    I’ve had great success using this method. HTH

    spiritfree1

    (@spiritfree1)

    18 years ago

    Syncbox, THANK YOU SOOOO MUCH. You are a lifesaver. I just kept believing and believing and encouraging myself that there HAD to be a way to recover all my work, and my search led me to this post.

    I appreciate you so much.

    (I don’t post to forums, but I had to register just to say, “Thank you!”)

    Best,
    SpiritFREE1

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Backup and Restore MySQL Database’ is closed to new replies.