Announcement

Collapse
No announcement yet.

Need help with moving large databse to new server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • LKM
    replied
    MySQLDumper has never failed to export and import any vBulletin SQL database for me. All you need is FTP access to upload the files, and to create and set permissions for several work folders on Linux servers if the host server runs with safemode enabled.

    Leave a comment:


  • beishe8
    replied
    Originally posted by Videx View Post
    Don't you have cpanel? Use it to download a one time db backup.
    Yes. That backup is going to be created on the server,all databases included.
    With FTP it's possible to dowload.
    On the computer have to unzip it.
    Keep the one needed,delete the others.

    Leave a comment:


  • ecrist
    replied
    You may be able to connect to the database directly. You can try connecting from your new server with the mysql command as follows:

    Code:
    $ mysql -u <user> -p<password> -h <hostname>
    Replace <user> with your database user name, <password> with your database password, and <hostname> with the IP address of your old forum server. Note that there is NO space between the -p and <password>. If this works, then try the following to perform a remote backup:

    Code:
    $ mysqldump -c -x -u -q <user> -p<password> -h <hostname> <database_name> > old_db.sql
    Same as above, but replace <database_name> with the name of your database within MySQL. Note the extra > character is intended, and tells the shell to redirect the backup to a file named old_db.sql. You should be able to restore this on your new server.

    Enjoy!

    Leave a comment:


  • Videx
    replied
    Don't you have cpanel? Use it to download a one time db backup. But really, you should have had daily db backups being made and downloaded.

    Leave a comment:


  • dawges
    replied
    I do have ssh on the new server now just not on the old one. Whats would be the best way to export the database from my current host and then add to the new server? I have never done this before i am at a loss and pretty much need help.

    Leave a comment:


  • Videx
    replied
    I don't know any way except with ftp and SSH access. Is there some reason your host won't give it to you (it's normal to have to request ssh access via a tech support ticket)?

    Leave a comment:


  • dawges
    started a topic [Forum] Need help with moving large databse to new server

    Need help with moving large databse to new server

    Sorry, i know this has been asked however, i can only find help for shell access which i dont have. My database is around 150 meg and of course cannot be imported with phpmyadmin. I have tried everything i could find. Bigdump, I even tried to do a few tables at a time. Can anyone help me? Thank you.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X