What was you bigest Mysql Database that you Imported/exported

[ThE.BeSS]

What was you bigest Mysql Database that you Imported/exported
I exported and imported mysql database of my forum 59.3MB but i had an problem with importing because the Freehosting acepted only 8MB mysql database
so i had to separate the database in 8 parts that was very difficult work

[Dan]

Hi,

If you are having issues importing your current SQL database, Support will transfer / import your database for you upon request

[Confused2]

Originally Posted by Dan

Hi,

If you are having issues importing your current SQL database, Support will transfer / import your database for you upon request

In fairness that might seem obvious from the inside .. but as a new customer I had no idea of the level of support available - I got locked out by a firewall and needed tech support (twice) while adding 33,000 records by a rather (very) primitive technique. If you can/will do it then why not put it in your promo stuff?

John.

[Dan]

Originally Posted by Confused2

In fairness that might seem obvious from the inside .. but as a new customer I had no idea of the level of support available - I got locked out by a firewall and needed tech support (twice) while adding 33,000 records by a rather (very) primitive technique. If you can/will do it then why not put it in your promo stuff?

John.

It's classed as "transfer your website / data" I guess

[Confused2]

Originally Posted by Dan

It's classed as "transfer your website / data" I guess

.. that's just too obvious

[Administrator]

Originally Posted by ThE.BeSS

What was you bigest Mysql Database that you Imported/exported
I exported and imported mysql database of my forum 59.3MB but i had an problem with importing because the Freehosting acepted only 8MB mysql database
so i had to separate the database in 8 parts that was very difficult work

The Biggest Database I migrated from one server to another server was 17GB and the second biggest was 11GB. Both these Databases were vBulletin Forum databases of 2 biggest forums in the world.

Migration of such Databases can be done only if you get root access of both servers, but migration of Database below 2GB size can be easily done by restoring the .sql dump on server. I've rarely used the import wizard in PHPMyAdmin as it fails most of the times even if you try to restore a Database of 200 - 400 MB. cPanel backup restore wizard is the best option to restore a Database below 2GB size.

[Confused2]

There have been some dark days recently ..
I suspect cpanel restore wanted a sql.gz (?) file and my (windows) Mysql Administrator only produces uncompressed .sql files. I've probably got a command line mysqldump somewhere .. but I've mostly lost the will to use the command line. A note "run mysqldump /switches" (even now) might be helpful.

[Dan]

Originally Posted by Confused2

There have been some dark days recently ..
I suspect cpanel restore wanted a sql.gz (?) file and my (windows) Mysql Administrator only produces uncompressed .sql files. I've probably got a command line mysqldump somewhere .. but I've mostly lost the will to use the command line. A note "run mysqldump /switches" (even now) might be helpful.

PHPMyAdmin allows restoration of uncompressed .SQL files

[Confused2]

Hmm .. yes, PhpMyAdmin does say it can import up to 51Mbyte .. I did try it (honest!) but it didn't take my 15Mbyte .sql file. Reason unknown ( ?) .. and I'm not going to try again just so's I can say what happened. In a previous life the cpanel restore worked well .. so I'da used that if I could have remembered how to work the mysqldump thing.

[Administrator]

Originally Posted by Confused2

Hmm .. yes, PhpMyAdmin does say it can import up to 51Mbyte .. I did try it (honest!) but it didn't take my 15Mbyte .sql file. Reason unknown ( ?) .. and I'm not going to try again just so's I can say what happened. In a previous life the cpanel restore worked well .. so I'da used that if I could have remembered how to work the mysqldump thing.

This can be due to the php file size limit enforced within the php.ini configuration file. We can change its settings for VPS or Dedicated Server customers, but there's a different procedure for shared hosting customers.

Shared hosting customers can use a separate php.ini file in their hosting account which can be made their dedicated php configuration, but only limited php functions can be modified through custom php.ini file hosted within your account.

[Rachel]

Originally Posted by ThE.BeSS

59.3MB but i had an problem with importing because the Freehosting acepted only 8MB mysql database so i had to separate the database in 8 parts that was very difficult work

You cannot expect much from a FreeHost.. I understand how difficult it would have been for you..

For anyone else, who has an account with WHUK, you can leave this difficult part for the support team

[Mentori]

59.7mb, cpanel didn't allowed that, but i had charge with mysqldumper.

[SynapticG1]

So... I am a little confused about maximum limits. What is the absolute maximum size limit of a database for uploading? Or does it nave have one, I guess I wanna know if the world is round or flat.