Thread: Database Dummy here...

Hey guys...

I am a total database dummy........ but I am trying to import the zipcode data into the database.
First I broke up the over 10MB file into four smaller files. They are all under 3 MB now.
I go into phpmyadmin and click on "import".... then I browse for the first file.... and select...... then click "go".....
I am getting a 404 in phpmyadmin when I do this....... am I doing something wrong or do you think this might be server error?

Thanks,
Ann

you should import them with ssh.....i finally figured this out after doing 3 or 4 fresh installs of dolphin and importing the zips through phpmyadmin each time......it takes forever.....with ssh it's under 2 minutes with no breaks....i typically unzip the file.....upload it to my server.....go to the folder where the .sql file is.....then use this

Code:

$ mysql -u username -p -h localhost databasename < data.sql

it will then ask for your password for you database.....think about it for a couple of minutes....then you'll go back to the command line.....go to your db and make sure that the files were imported.....if you run into any troubles just post again and i'll see if i can help you out.

Thanks for your reply....
I am with hostgator....... and have to jump through hoops to get ssh.

Ann

well....then make the sql files as small as possible....and check the box to allow interruption if you come close to a timeout......i found that if i was anywhere near the file size limit it would give me the same error you're getting....sorry i can't be more help

Well..... I got it guys...

I went in and copied the sql file in chunks..... as large as I could possibly go without sending the unit into a funk... and I pasted them into the query window!! What a huge undertaking...... But its done now!!

The means was a bit archaic...... but effective nonetheless...... hehehe.

Thanks for your support
Ann

I was just helping someone with an upgrade.....ran into the same problem you were having with phpmyadmin.....they couldn't get ssh either......before trying the same process you did....i decided to switch browsers......the sql file uploaded with no problem.....almost immediately......for some reason though i kept gettting the 404 errors with ie......sorry I didn't have this answer a little sooner for you.....but hopefully it will help you and others in the future......George

Hey George.....

Thanks for the input.... I did try with other browsers. I tried with Crazy Browser and firefox. I think that I was screwing up with the size of the sql files. I didnt know how big or small to make them... and I think that the timeouts were giving me the 404s. But... I am guessing nonetheless. LOL.
Thanks again,
Ann

I use this from SSH - and it works well:

to dump database :

Code:

mysqldump -udbuser -pdbpassword -a -c -e -Q  dbname  > dump.sql

to import database :

Code:

mysql -D -udbuser -pdbpassword dbname  < dump.sql

Smoge