Wont upload my MySQL Backup!!!

[Astrift]

I just switched servers and on my last server I had cPanel and made a MySQL backup from it. Then I bought a new server with Direct Admin and now when I upload my backup it tells me that it has been successfully uploaded but when I check out the database with phpmyadmin there are no tables, no nothing. Can someone tell me why, or is this a bug!

 

[jmstacey]

Are you attempting to upload this backup through DirectAdmin or through phpMyAdmin?
How big is this file?
Check the .sql file ane make sure it's not trying to create the database as well.

 

[Astrift]

I am attempting to upload my database through directadmin. It is about 5mb and I am not sure if it is creating a database, but these are the first few lines in the SQL file. Maybe you can tell me if it is creating a database or not. And if it is, how would I fix it.

<--- SQL Code --->

-- MySQL dump 9.11
--
-- Host: localhost Database: username_dbname
-- ------------------------------------------------------
-- Server version 4.0.24-standard

--
-- Table structure for table `platinum_admin`
--

DROP TABLE IF EXISTS platinum_admin;
CREATE TABLE platinum_admin (
id tinyint(4) NOT NULL auto_increment,
username char(16) NOT NULL default '',
password char(32) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;

<--- SQL Code --->

 

[jmstacey]

You have increased the limit that PHP allows you to upload?

Simply deleting that portion of the code should do the trick leaving just the table and data insert commands.

 

[Astrift]

Problem Solved!

Well the problem is solved now. I removed the code you asked me to and it still did not work. Then I looked closer and is had a "(.gz)" next to the upload. Then I figured "Ahhh! Maybe I have to upload the .gz version of it, not the plain file." So I did and it worked! End of story.

Thanks anyhow!