If your tables are missing -- and they obviously are, I'd recommend it.

How big is your SQL backup?

Ok my DB is about 6.8 mb When i restore through cpanel if it says
Restoring Database

Does that mean its done?

-ing means ongoing or in the process of. -ed means finished or no longer processing. ;)

6.8 MB might be too big to restore through cPanel or phpMyAdmin. You might have to split it up into smaller chunks or restore via Shell/SSH.

how do i split it up? into chunks

The old DB might be corrupt

No. Its brand new.

You might need to edit config.php. You should just import via SSH.

And once again, please make more appropriate thread titles.

To split it up, just open the .SQL file in a text editor like Notepad/Wordpad and cut and paste chunks of the code into seperate files, just be sure that wherever you cut out ends in a semicolon (;).

You could also use a staggered importer like BigDump.

Or as Chris said, if you've got Shell/SSH it'd be easier to import it using that. It's probably not enabled by default, so you'll have to ask your Webhost to enable it for you.

I set it up for him through big dump :)

Link is here: http://www.gamerz-forum.com/forum/

So when i copy and paste the chunks out do I name the file the same as the DB?