Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2005
    Location
    Toronto
    Posts
    114

    Uploading A Big Mysql Backup

    hey im a bit of a n00b when it comes to dedicated servers and i was wondering how i would upload a big Mysql backup because whwn i had my cpanel with shared hsoting it was way to big to be uploaded through phpmyadmin or backup.

  2. #2
    Join Date
    Mar 2003
    Location
    tail -f /var/log/nerd
    Posts
    318
    FTP perhaps?

    C

  3. #3
    You should upload mysql bump file using FTP, and then try to use script (shell via web) for upload dump to mysql db.

  4. #4
    Join Date
    Nov 2003
    Location
    India
    Posts
    152

    Re: Uploading A Big Mysql Backup

    Originally posted by Sasukes
    hey im a bit of a n00b when it comes to dedicated servers and i was wondering how i would upload a big Mysql backup because whwn i had my cpanel with shared hsoting it was way to big to be uploaded through phpmyadmin or backup.
    You can first dump it into a sql file with following commands:

    mysqlduml -u dbusername --password=dbpass --opt databasename > backup.sql

    then gzip it to reduce the file size

    gzip backup.sql

    Upload it on the new box

    gunzip backup.sql.gz

    then restore it with the following commands:

    mysql -u dbusername -p databasename < backup.sql

    REgards

  5. #5
    Join Date
    May 2004
    Location
    Hungary
    Posts
    106
    You can also use a PHP script, called BigDump:
    http://www.ozerov.de/bigdump.php

Posting Permissions

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