Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    47

    MySQL Database Restore?

    I am transferring my web site to another provider. I try to transfer mysql database by download a backup from old provider and restore it using cpanel. Restore seem like succesful but when i check using phpmyadmin, its only created 10 tables while its suppose to have 21 tables. Any idea what really happened? Or can you all suggest me another way to restore the database?

  2. #2
    The database should be taken backup once again using the following command,

    mysql db_name < backup-file.sql

    In the above command you should be in /var/lib/mysql directory and you should have root access, if you don't have one contact you hosting company.

    In order to restore it,

    mysql database_name < path/backup-file.sql

    This will restore all the tables safely.

  3. #3
    Join Date
    May 2004
    Location
    World Wide Web
    Posts
    1,195
    Or if you don't have SSH (for mysql db_name < backup-file.sql you need shell access) you can use PHPMyAdmin to backup (export) the database and than try importing the same to new server using PHPMyadmin.
    RVH Cloud - Every day hosting solutions since 2003
    Shared Hosting Reseller Hosting VPS Dedicated Servers True 24 x 7 x 365 Support

  4. #4
    Join Date
    Oct 2004
    Posts
    47
    Thanks

    btw contactsonia, i cant find import command at phpmyadmin

  5. #5
    Join Date
    Oct 2004
    Posts
    47
    ouch!

    Everything is ok now, i should use SQL queries

Posting Permissions

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