How do i restore a SQL file?

[Dmiller]

Ok i need help on restoring this SQL file for one of my sites...Everytime i try to restore it, it doesn't create the tables so you cant see the information...PLEASE HELP...How do i restore it using only MyPhPAdmin and Cpanel?

[ergophobe]

If it doesn't create the tables, it's not doing anything at all, so start with verifying that. In order, check the following

1. the database exists.

2. you are "using" it (in the sense of the MySQL "use mydbname" command). I think in phpMyAdmin this would just mean that you are on the page for that DB, rather than the general page for you DB server or something.

Now, when I'm having trouble getting a DB dump to load back in, I usually start breaking it down.

1. Break out the CREATE statements and rebuild the structure first. Verify that all tables exist.

2. Break out any really big table data (like if you have more than say 2M in any given table) and upload that data in chunks smaller than 1MB so you don't get timeout errors.

3. Upload the data for your smaller tables.

If you have shell access, you can save yourself some trouble by uploading the dump file as a zipped file and then unzipping and loading into msql qithout worrying about timeout issues, but since you want a CPanel/phpMyAdmin solution only, that won't really help.