Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007
    Posts
    2

    Unanswered: fastest way to import backup db

    I have exported mysql database file which is over 100mb and wants to import back. I've tried BIG DUMP and it takes forever. I've also tried import command of phymyadmin but got this error - "Fatal Error: Maxiumum execution time of 300 seconds exceeded". Can anyone tell me the fastest way to import back.
    P.S I'm trying this on local host and I'm also server admin.

    Apache : 2.2.4
    Mysql : 5.0.4.1
    Php : 4.4.7
    Windows Xp SP2

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Use the command line (shell login)

    mysql -u [username] -p [databasename] > [backupfile.sql]

    n.b. got my > syntax the wront way round first time. changed now.
    Last edited by aschk; 06-04-07 at 04:50.

  3. #3
    Join Date
    May 2007
    Posts
    5
    Hi Homer,

    Check out these links on the official MySQL documentation. These links provide detailed instructions on Backup and Restoring database.

    http://dev.mysql.com/doc/refman/5.0/en/mysql.html

    http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

  4. #4
    Join Date
    Jun 2007
    Posts
    2
    Thanks guys

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •