MySQL :'(
- Started
- Last post
- 21 Responses
- lifeinsodium
I am running a phpBB on this site. And what I want to do is move this phpBB to a different site. So I made a backup of the database and it is 101MB
:'(
phpMyAdmin is unable to restore a database this big. What do I do? Any suggestions would be appreciated.
- unfittoprint0
you coluld try to export the database in smaller files: one for the threads table, other for the posts, another for the usersID...
Another advice:
you could try esKUEl. It's nicer and more user-friendly than phpmyadmin
- lifeinsodium0
i could try one file for each table but the word on the steet is that phpMyAdmin can't handle anything larget than 1MB.
So I am looking at 100 files
:'(
There has got to be a better way of doing this. And can esKUEL handle big databases?
- unfittoprint0
I find it odd that phpMyAdmin couldn't handle files larger than 1mb... that would very small databases.....
I didn't have that problem with eskuel. But are you sure that's a phpmyadmin problem?
- lifeinsodium0
hmmm.
your response has give me hope. so i will try again.
if i dont come back in 15 minutes then... umm... wait longer.
- lifeinsodium0
24 tables done. 4 to go. But those 4 are a biatch!
- unfittoprint0
using phpmyadmin?
- enobrev0
sorry for jumping in late.. i've seen phpmyadmin have trouble with large files, but that's usually due to php timeouts or even http timeouts from the file upload...
I would really recommend sshing into the server and doing it via commandline mysql if at all possible
- lifeinsodium0
26 done. 2 to go.
Using Eskuel for the 12MB table. Lets see if it works.
The last table is 54MB :(
- lifeinsodium0
eno - i tried the ssh thingy. but my biatch hosting people dont allow connecting with mySQL directly.
I mean if I have to create a new database I have to ask them to create if for me. I guess that what's you get for getting cheap hosting.
- Redmond0
I find it faster to ftp through command-prompt, personally :B
- lifeinsodium0
so i ftped the dump on to the server. then i tried the command:
>mysql -u [myusername] -p [mydatabase] < backup.sql
this is the error it gave me:
Enter password: ERROR 1130: Host 'localhost.localdomain' is not allowed to connect to this MySQL server
:(
- lifeinsodium0
and Eskuel can't handle a database this big either.
- JazX0
switch to Flash -> PHP -> SQL -> PHP -> XML -> Flash set up. no just joking good luck ;)
- sp0
i'm not sure if it is the software that is the problem...there might be some restrictions on your host.
i believe i've exported, backed up and restored databases that large through pma before...
- 187LockDown0
set up a new forum with a fresh DB. Then replace it with the old one? Make sure its named the same?
- lifeinsodium0
but the problem is with restoring the db. for some reason phpMyAdmin is not able to handle it because it is a pretty big db.
- enobrev0
sp could have something.. depends on your db limitation..
also phpmyadmin is still restricted to file transfer limitations. If your 4 tables are 50MB altogether, the browser is not going to do it. Whether it's supposed to otr not, it will fail miserably.
Also, not only do you have to wait for the browser to upload, you have to wait for mysql to flip thorugh all the inserts, which can take time if it's a lot of text (which i presume it is)
I had the same situation, and went the tedious route (phpBB and hte guy had been hacked a couple times so no ssh - bastard).
Basically cut up the import files into 2 - 5 MB chnks (whatever you can get to work) and import them one by one. It's a pain in the ass, but it works.
You could also dig through their code to find their code that does the actual importing via a file. Grab that code, change it up to open up your files from the local file structure, ftp them up and run your script.
- lifeinsodium0
i understand the chopping into small chunks part. and it will be a pain in the ass but is doable.
please explain this part in language that a dodo like me can understand "You could also dig through their code to find their code that does the actual importing via a file. Grab that code, change it up to open up your files from the local file structure, ftp them up and run your script. "
thanks :)
- enobrev0
well, that was if you are at least mediocre with your php.
Basically phpmyadmin has some code that reads the sql your uploaded file - probably a mysql command.
If you dig through and find the code taht does it, copy it and make your own import script that, instead of taking a form post, actually opens up the file from your server directory and imports it.
This will at least cut out the need to upload the file via the browser before importing which probably hinders the process before it even gets to the import.