• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Problems restoring SQL database

G

Gouk

Guest
#1
Hi everyone ;)

I am having problems restoring a 8MB SQL database as I am moving to another host.

When I try to restore it via phpMyAdmin, it times out on me while I am uploading it. I don't have Shell or Telnet access to the host either as its not a MAJOR site anyway just for some friends.

I can upload a 2MB or less database just fine.

Does anyone know a solution to this problem?
 
#2
First off, phpMyAdmin is great EXCEPT for uploading big databases. This is because PHP (which phpMyAdmin uses) has an upload limit. This is, in default, set to 8 MB. So, if your database is just over 8 MB it can't be uploaded to phpMyAdmin. One way to fix this is to cut the .sql file into smaller pieces (4 MB, halfway). Just cut it between queries and it should work (I think).

Good luck!
 

Members online

No members online now.

Latest posts

Latest profile posts

Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,961
Messages
673,239
Members
89,014
Latest member
sanoravies