800mb sql fiile import taking FOREVER
- Thread starter efeezy
- Start date
800MB should only take around 30 secs. No reason for it to take longer.
There's a problem besides the import. I have no idea what, as it could be 1 of 500 things. mySQL itself would have no problem importing an 800MB file though.
I've imported say 3GB databases before in a minute or two, so 800MB is a non-issue. There's something else stalling it.
There's a problem besides the import. I have no idea what, as it could be 1 of 500 things. mySQL itself would have no problem importing an 800MB file though.
I've imported say 3GB databases before in a minute or two, so 800MB is a non-issue. There's something else stalling it.
If you're sure the data is sane, put this at the top of the import file:
then put this at the bottom:
Code:
SET UNIQUE_CHECKS=0;
SET FOREIGN_KEY_CHECKS=0;then put this at the bottom:
Code:
SET FOREIGN_KEY_CHECKS=1;
SET UNIQUE_CHECKS=1;
Try SQL Bigdump. Import the b or gzip in with it and it should be faster that using another import manager because it breaks it into pieces.
This.
If you're trying to upload the file to the server, and import is simultaneously, you're doing it wrong.
Ok it's obvious I'm a damned fool..I don't mind admitting that.
Now that we've cleared that up, instead of doing an upload/import what's the absolute easiest way to get an 800mb sql file into myphpadmin? Pretend for a second you were going to teach a compete retard how to do it, that's how you have to deal with me on this one. :thumbsup:
Now that we've cleared that up, instead of doing an upload/import what's the absolute easiest way to get an 800mb sql file into myphpadmin? Pretend for a second you were going to teach a compete retard how to do it, that's how you have to deal with me on this one. :thumbsup:
ssh or telnet to server.
do:
mysql -u USER -pPASSWORD
at mysql prompt do:
use yourdatabase
source filename.sql;
That'll suck in the sql file at the max speed your server can handle.
???
Profit?
do:
mysql -u USER -pPASSWORD
at mysql prompt do:
use yourdatabase
source filename.sql;
That'll suck in the sql file at the max speed your server can handle.
???
Profit?
1.) Login via FTP, and upload the .sql file into the first directory you land in. Don't change directories.
2.) Open up Putty, and connect to your server. No username needed.
3.) Once connected, you'll be prompted to enter your username & password.
4.) Once logged in, type:
mysql -u USERNAME -p PASSWORD DBNAME < filename.sql
5.) Delete the .sql file from your server.
6.) Enjoy your new database!
2.) Open up Putty, and connect to your server. No username needed.
3.) Once connected, you'll be prompted to enter your username & password.
4.) Once logged in, type:
mysql -u USERNAME -p PASSWORD DBNAME < filename.sql
5.) Delete the .sql file from your server.
6.) Enjoy your new database!
#3 is giving me the trouble. Putty prompts me for username, which I enter, but then when it the password prompt comes up on the next line, it won't let me type anything and it just shows a green box. So I have to exit out and can't go any farther. Something's fouled up.
LOL... it's supposed to do that. Just keep typing your password, and push enter. It's not supposed to show any characters. Security feature, so you can't even see the length of the password.
Oh, and after inputting your password, there's about an 80% chance you're going to get told you don't have shell access. In that case, contact your web host, and ask them to open up SSH on your account.
Oh, and after inputting your password, there's about an 80% chance you're going to get told you don't have shell access. In that case, contact your web host, and ask them to open up SSH on your account.