MySQL Database restore

[TheGuardian]

Howdy folks,

Just curious on how Vodahost assists on the restoration of a mysql database from one server to another.

We have a db that is 61mb and it seems the limit set in myphpadmin is 51mb or so. Tried it anyway and of course it timed out. I have also tried the "BigDump" program that was suggested in another thread, but it gives me a couple of errors and it will not work either. The only way I know how to ensure an almost perfect restore is to do it with shell access, which of course Vodahost does not grant access to users.

I was just curious if anyone else here had any other methods of restoring a db so that we can get our site up and running. I am stuck and cannot do anything else until this happens.

On an added note, we use Vbulletin the same as VodaHost does so im sure you can understand the urgency.

Thank you

Nick

CLIENT ID #19083

[Watdaflip]

Re: MySQL Database restore

Restore the table structure first, and then insert the contents of the table in multiple queries. Just break it down into a couple groups.

[TheGuardian]

Re: MySQL Database restore

Restore the table structure first, and then insert the contents of the table in multiple queries. Just break it down into a couple groups.

Thanks for the reply Watdaflip. Are you talking about restore the table structure manually? I have 209 tables to do, thats a TON of work. Id rather have this automated. I realize this isnt the largets DB in the world, but its not small either. I have cut it up but have one table that is over the proposed limit. Im not a noob with DB, but not an expert... i know how to do it when it works, but its not working here. Im despirate. Put a ticket in 24 hrs ago here and have not heard one response yet. I dont know what to do.

[TheGuardian]

Re: MySQL Database restore

Ok, i took your advice and split it up. I was unable to get one table up because again, the dad gum limit. It is not looking good. Ill take a crack at it tomorrow.

[Watdaflip]

Re: MySQL Database restore

You don't necessarily have to do it table structure and then the contents since you have so many tables.

Try just doing like 20 tables and the contents of those 20 database. This should be within the limit, just do that a couple times until all the tables are restored

[TheGuardian]

Re: MySQL Database restore

Wat,

I took your advice and was able to restore 97% of the db. I have one table that is 61mb. I made a mistake earlier when I said the entire DB was around 60, that was compressed. Anyhow, I have most of my db restored but this one table. It s the attachment table which is pretty important.

[TheGuardian]

Re: MySQL Database restore

Ok, its been a week now and I have not been successful in restoring my DB. ive tried almost everyway possible to get it restored. Does anyone have any other ideas on how I can get this done.

[Karen Mac]

Re: MySQL Database restore

Have you asked voda host via support ticket if they will do this for you?
could be this would solve your problems.

Karen