Restoring A DB with phpMyAdmin 2.2.5

[Hikusaak]

Before my disasterous attempt to convert to vb3 failed, I dumped my vb2's forum database onto my computer's hard drive and now I would like to restore all the tables from my vb2 database into a new database. The problem is I don't know what specific query I'm supposed to run. I went looked at a MySQL manual and the closest thing I saw was Restore Table Syntax.


Edit: By the way the database saved on my hard drive is already in .sql format.

[RichM]

Is it larger than 2mb? If it is you won't be able to restore it using Phpmyadmin as the maxmum php upload size is 2mb.

[Hikusaak]

Nevermind the table I backed up was corrupted so I'll have to find some other way to do it.

[john_rsd]

Is it larger than 2mb? If it is you won't be able to restore it using Phpmyadmin as the maxmum php upload size is 2mb.

Hmmm, I was about to post almost the same question, I made a .sql backup from within vb and the .sql file is 2,888 kb.

When I try to restore it via phpmyadmin 2.5.5 I get an error No SQL Query I also tried the hosts restore method via vDeck but same idea (probably uses phpma anyway). there was no time-out issues and the files seemed to upload fine.

I also uploaded it to the server and tried to restore from there to save upload time-outs but sam issue.

Is this some limitation of phpmyadmin that can be worked round? What puts this 2mB limit in place?

I would like to move the DB, but I have no Telnet/SSH access. So I would like to try and do it myself before asking the host to do it for me.