How to handle large database

  • Hi,

    I am making a application which is going to quite big and will create large size database ( approx 5-10GB in size).

    Taking the database backup and downloading it is simple process using phpmyadmin interface .

    But I am worried that if I shift the website account to some other server than how database can be uploaded/ restored back using the phpmyadmin.I am sure regular restoring will time out the operation.

    Is there any links or tools available which can be used to restore the database.

    Thanks & Regards,
    Ajay
    OBizTek.com

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

  • have you asked this question on cooking forums, and pregnancy forums too? While not quite as bad as those, this is certainly not the best place for questions about specialised database concerns.

    Your question has nothing to do with wordpress. I suggest you ask on a mysql forum.

    Simply put, you won’t be able to restore a 5-10GB MySQL Database through phpMyAdmin. You’ll have to upload it to the server and use SSH (Shell) to restore it from the command line.

    Trying to upload that large of a database through the browser will not only timeout, but any data from the database also has a good chance of corruption.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to handle large database’ is closed to new replies.