Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2005
    Posts
    47

    backing up a 70MB mysql database, without using ssh. HOW?

    I have an ipb forum with a 70mb database. I need to move it. Dump files from phpMyAdmin and cpanel backup stop at 14MB, so that is useless. And Ionhosting does not allow shell access.

    How else can I do it? Im currently waiting for a response from them on the same question, but they have just suspended my account once more for using too much cpu, and are ignoring my email, and i am angry, and thinking of moving to some other host, but before I send them to hell, I need to see if I can save my forum somehow.

    help.

  2. #2
    Join Date
    Mar 2005
    Posts
    93
    If they could do it with ssh for you, it could be done in a matter of minutes.

    I have not run phpbb in awhile, so I don't remember if there is a utility in there or not.

    Using phpMyAdmin, you can select which tables to Export once you select your database.

    I would try exporting 5-10 tables at a time, and choose the gzipped method for exporting.

    When you want to re import them, you can do the same thing, import 5-10 tables at a time again.

  3. #3
    Join Date
    Jul 2005
    Posts
    47
    i think it would still be the same, cos the posts table is 52Mb alone

  4. #4
    Join Date
    Mar 2005
    Posts
    93
    Same concept, in phpMyAdmin there is an area to put how many rows you want to dump.

    So on your posts table, if you have say 80,000 rows only export the first 20,000 rows.

    Then on your next dump of the posts table, dump 20,000 more rows starting at 20,001 and so.

    When you get all of the posts dumped, you can merge all the files into one main .sql file for your posts if you wish.

  5. #5
    Join Date
    Jul 2005
    Posts
    47
    hmm... i may try that.
    though right now im in the process of getting the host to send the full backup to me, and if they send me a 14 mb file, i have yet to decide whether to laugh or cry...

    cheers, anyway!

  6. #6
    Join Date
    Apr 2002
    Location
    Las Vegas
    Posts
    797
    I use this php tool for all my client with large database[s]. I also used it on a 80MB vb forum. works on any database

    http://tools.invisionize.com/db/inde...f/3144/size/lg

  7. #7
    Join Date
    Jul 2005
    Posts
    47
    ooh thats very interesting! its for invisionboard 1.3 as well which is the one i have! im gonna try that!!!

    as soon as my account starts working again.

    grrr.

Posting Permissions

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