I backed up this mysql database through cpanel and saved it on my hard drive. Now Im reimporting back in cpanel and it takes me to a white page that says "Restoring Database" then has all the scripts below that. After its done, I check the size of the database through cPanel by clicking on mysqldatabases and it says its 35mb when the original size was 66mb I have reimported it many times and I got as high as 55mb. Everytime I import it I get a different size. What is the problem?
i guess The problem is with your internet connection... its not uploading database correctly in one instance. Try to upload from a high bandwidth net connection.
My guess is that the script that runs to import the database file is timing out and what you see is what got done before it times out. Hence why one time it is 35MB and another time 55MB (or other varying numbers). Importing a database that size in one chunck almost never works. MySQL Database File you saved on your hard drive should be a Plain Text file that you can open in Notepad or similar text editor. My advice would be to split the file into at least three different pieces, maybe more. There are lots of lines in the file that have nothing on them (ie: link the spaces between my paragraphs) and you can generally break the file up at any one of them. Usually the Database Text file is in a format such as CREATE table, followed by INSERT, INSERT, INSERT. Keep the CREATE and INSERT together for each table to make it easier (but it is not necessary). When the import is processing, it reads the Database File one line at a time and executes that command. That's why you always see a partial database... because so many commands got executed before the script timed out (or gave up).