How do I check if MySQL database is to large for phpmyadmin

[Webmin]

I want to export my phpmyadmin using this tutorial

Step 1 - Backing up using phpMyAdmin

Note: Most good hosts provide phpMyAdmin (mySQL administration). If you do not know where it is or even if it exists on your server, just get in touch with your host.
Login to phpMyAdmin.
Select the database you wish to use.
On the navigation bar on the top, select "Export" (besides SQL, Structure, Search, Query... etc.)
You should now be presented with a nifty little page which shows all the tables in the database, SQL Options and Save Types. *
To backup the whole database, click "Select All" under the list of tables in the page.
To backup a selected few, just hold down CTRL on your keyboard and select the tables you wish to backup (release the key when all selecting is done).
SQL Options can be left as default, but I suggest ticking the "Add DROP TABLE" option as if you are restoring a backup on a database that already exists and has the table in it - you will get a lot of errors! This way, by ticking the "Add DROP TABLE" option you will avoid the errors. For more information on the options just click the little "?" icon after SQL Options.
If you want to save the backup as a file (recommended) then tick "Save as file" - Leave file name as is or edit for your needs. Select "gzipped" as compression. Now click "Go". If asked, choose "Save to disk" and save it wherever on your computer (it may take sometime depending on the size).
If you want to show the whole backup SQL on your browser window, don't tick "Save as file" - once you have selected the tables you wish to backup (explained in step 5/6) click "Go". The page will now change and should show the SQL information (it may take sometime depending on the size). Copy and paste it to a text file or do whatever you want with it!
Note: Yes, the tables of the database will be shown to the far left in a frame, but they will also be displayed in a different form on this new page to the right in phpMyAdmin.

Congratulations! You have successfully backed up your database / selected tables!

Step 2 - Restoring your database using phpMyAdmin

Note: Most good hosts provide phpMyAdmin (mySQL Administration). If you do not know where it is or even if it exists on your server, just get in touch with your host.
Login to phpMyAdmin.
Select the database you wish to use.
On the navigation bar on the top select "SQL" (besides Export, Structure, Search, Query... etc.)
You should now be presented with a little page which allows you to run SQL query/queries on the database, either by inputting the query/queries to the input box or by locating a text file on your computer.
You now have 2 options: 1) Paste the SQL which you backed up earlier in the "Input Box" and click "Go" or 2) If you saved the file on your PC then use the option below the first one; Click Browse > Locate the File > Click "Go". (Note: Most servers set a "Max File Size" for uploading the SQL, the size appears beside the Browse button.)
It may take sometime for the file to be uploaded and fully run, so give it a chance. Once it worked, it will bring you back to the same page and should confirm if all went well "Your SQL-query has been executed successfully: The content of your file has been inserted."
Congratulations! If all went well, you have successfully restored your backed up database!

I know there is a size limit, how do I find out if my database is too big to be exported and imported onto my new server?

Thanks

 

[Whoo]

As I suggested in the previous thread I would use Bigdump. I have seen that you wrote about importing a 900MB dump via file upload, I would really really not go for that option.

Upload the .sql file via SFTP, FTP or transfer it from your previous host using SCP. Then use bigdump or the standard MySQL command line command to import it.

I find it strange to see that you are going looking for a work around for your "I cannot login via SSH problem" instead of actually fixing the problem itself

 

[zen]

Bigdump indeed

OR

Export the database tables in several pieces so you can import them with phpmyadmin the normal way

OR

Edit upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. You may also need to change Maximum execution time setting.