PHPMyAdmin ?

[FalcomPSX]

OK, so I have a PHP MyAdmin installed and working(sort of). Anyway, My old website, I dumped a mysql database from there to a .sql file...and that worked ok(using the export tab). Problem is, there's no "import" tab, or button or anything and i have ZERO clue how to get it into the new server...advice?

[crouse]

To dump mysql database from a telnet session:

mysqldump -u [username] -p[password] [database] > [backup_file.sql]



To RESTORE a database via a telnet session:

Code:

mysql -u [username] -p[password] [database] < [backup_file]


Example:

Code:

mysql -u yourusernamehere -p yourpasswordhere nameofnewdatbasehere < nameofyourbackuphere.sql

Hope this helps.....

[Carl-cox-]

there is a impor feature in phpmyadmin all you do is create all the tables you had first, then in the table part choose the sql tab

[FalcomPSX]

ok, i got it figure out, mostly, I got all my tables back up except for one. I got them up by using the SQL tab and uploading a text file, problem is it limits me to 2048K for the file size. The last file i need to upload is just under 3MB...so any ideas how to get it to upload? tried uploading as a gzip, but that won't work either.(PS this is a windows install, not linux)