Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Can't move database - too large

  1. #1
    Alex Fraiser's Avatar
    Alex Fraiser is offline Newbie Net Builder
    Join Date
    Jun 2009
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't move database - too large

    Hey guys,

    I am trying to move my larger blog to a new host because our current host is being completely unreasonable with numerous things.

    When I backup the database via phpMyAdmin and try to upload that backup to the new host, it tells me the file is too big.

    I have tried to run the "Big Dump" script, but it's no good.

    Does anyone have an experience moving a large mySQL database and getting through this problem? And if so, can you help me? I'd really like to move my host, but this damn limit is stopping me!

    Thanks guys.

  2. #2
    KDisk's Avatar
    KDisk is offline *********
    Join Date
    May 2009
    Location
    Miami, Florida
    Posts
    124
    Thanks
    0
    Thanked 3 Times in 2 Posts
    Hello,
    Are both hosts using cPanel, if so, you can log into cPanel and select Backup Wizard > MySQL Databases. This will download a compresed snapshot of your databases. On the new host log into cPanel and Select Backup Wizard and restore.
    Keith I. Myers
    K-Disk Networks - Reseller Hosting Specialists
    Affordable Semi-Dedicated Reseller, Master Reseller and Alpha Reseller Hosting Done Right
    End User Ticket Support Available | FFMPEG Active on All Plans

  3. #3
    Alex Fraiser's Avatar
    Alex Fraiser is offline Newbie Net Builder
    Join Date
    Jun 2009
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by KDisk View Post
    Hello,
    Are both hosts using cPanel, if so, you can log into cPanel and select Backup Wizard > MySQL Databases. This will download a compresed snapshot of your databases. On the new host log into cPanel and Select Backup Wizard and restore.
    Yes, they both use cPanel...I will look at that, thanks.

  4. #4
    Alex Fraiser's Avatar
    Alex Fraiser is offline Newbie Net Builder
    Join Date
    Jun 2009
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by KDisk View Post
    Hello,
    Are both hosts using cPanel, if so, you can log into cPanel and select Backup Wizard > MySQL Databases. This will download a compresed snapshot of your databases. On the new host log into cPanel and Select Backup Wizard and restore.
    That's still too big.

    Would copying and pasting like half of the file into a new file, and uploading the two halves work? I am thinking of trying that, as I don't see why it couldn't work.

    Yeah lol, I'm desperate now.

  5. #5
    billcrust is offline Unknown Net Builder
    Join Date
    Jun 2009
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Is it a wordpress blog? If you don't have too many plugins that store table data, you might simply want to export and import using wordpress.

    Exporting the data should be easy, importing it is where you need to split your sql files in multiple files and upload one by one.

  6. #6
    KDisk's Avatar
    KDisk is offline *********
    Join Date
    May 2009
    Location
    Miami, Florida
    Posts
    124
    Thanks
    0
    Thanked 3 Times in 2 Posts
    Alex,
    Please feel free to drop me an e-mail @ KMyers @ K-Disk.com and I will be happy to offer some one-on-one assistance with this
    Keith I. Myers
    K-Disk Networks - Reseller Hosting Specialists
    Affordable Semi-Dedicated Reseller, Master Reseller and Alpha Reseller Hosting Done Right
    End User Ticket Support Available | FFMPEG Active on All Plans

  7. #7
    Alex Fraiser's Avatar
    Alex Fraiser is offline Newbie Net Builder
    Join Date
    Jun 2009
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by billcrust View Post
    Is it a wordpress blog? If you don't have too many plugins that store table data, you might simply want to export and import using wordpress.

    Exporting the data should be easy, importing it is where you need to split your sql files in multiple files and upload one by one.
    Yes, it's a Wordpress blog. I'm pretty sure that it's the plugins that are giving me the errors. I am going to try to split the files, do you know of a fast way to do it? I tried copying and pasting it but there are thousands and thousands of lines and it would take forever.

    Quote Originally Posted by KDisk View Post
    Alex,
    Please feel free to drop me an e-mail @ KMyers @ K-Disk.com and I will be happy to offer some one-on-one assistance with this
    If I can't split the files I will definitely email you for sure. Thanks.

  8. #8
    xxtoni's Avatar
    xxtoni is offline xxtoni
    Join Date
    Jan 2010
    Posts
    353
    Thanks
    16
    Thanked 42 Times in 34 Posts
    WoW this is definitely something,how big is your database,it should be quite large if it cant be moved,maybe you could delete some tables that can be replaced

  9. #9
    TopDogger's Avatar
    TopDogger is online now Über Hund
    Join Date
    Jan 2009
    Location
    Hellfire, AZ
    Posts
    3,107
    Thanks
    350
    Thanked 919 Times in 703 Posts
    You can also backup and restore individual tables using phpMyAdmin.

    If you are using wassup, that could be your problem. I stopped using it because it is an incredible resource pig. If you are using that plugin and you have not changed the default settings, it keeps building history forever and tables get very large. You can delete the history in the configuration screen.
    "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." -- Benjamin Franklin


  10. #10
    xxtoni's Avatar
    xxtoni is offline xxtoni
    Join Date
    Jan 2010
    Posts
    353
    Thanks
    16
    Thanked 42 Times in 34 Posts
    Quote Originally Posted by TopDogger View Post
    You can also backup and restore individual tables using phpMyAdmin.

    If you are using wassup, that could be your problem. I stopped using it because it is an incredible resource pig. If you are using that plugin and you have not changed the default settings, it keeps building history forever and tables get very large. You can delete the history in the configuration screen.
    What TopDogger suggested is a very good idea if you dont have any other choice,but that has to be quite a large DB if you cant move it any conventional way

Page 1 of 2 12 LastLast

Similar Threads

  1. Best way to move up in Digg?
    By nicolebeckett in forum Social Bookmarking
    Replies: 6
    Last Post: 26 August, 2011, 15:55 PM
  2. Replies: 3
    Last Post: 1 January, 2011, 11:27 AM
  3. [WTS] WordPress on the Move
    By iowadawg in forum Marketplace
    Replies: 0
    Last Post: 20 November, 2010, 00:16 AM
  4. The Move is On
    By Menard in forum General Chat
    Replies: 1
    Last Post: 10 September, 2009, 15:40 PM
  5. Move over Spam....
    By m42 in forum Entertainment
    Replies: 1
    Last Post: 10 April, 2009, 18:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

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