Now, about that USA database....

[vkaryl]

and I will assume that this will apply to the others as well.

Most of us probably have "common garden-variety" hosting plans. We manage quite nicely for the most part with phpMyAdmin. The one thing that your database files don't take into account however is that most of those "normal" hosts we use these days only allow you 300 seconds (5 minutes) to import a database through SQL.

The USA database uncompressed is about 3MB. I was unable to import that large a file before it timed out. So I split the database in half, and gzipped it. See, that's the other problem: phpMyAdmin won't import a zip file, only text or gzipped....

Suggestion: gzip the distros. Even at that the halves of the original db were 128kb, and ran right up on the time limit.... I have the feeling that the Europe db is even larger than the US one....

[David]

It's certainly no fun cutting and pasting repeatedly into phpmyadmin. :twisted:

[vkaryl]

No. It's not. And I wouldn't consider doing it that way, which is why I gzipped it into halves.

[VolksMate]

Hi,
I was looking for a easy way to dump large data into Mysql. Did some search on the net and found Ozerov's bigdump. It works amazingly.
here is the link.
http://www.ozerov.de/bigdump

Thank you guys for the PHP Link Directory. I have downloaded and installed it but didn't open to public yet.
Great job.

[vkaryl]

Volksmate, thanks for the link. I will check it out, and hopefully it will solve various problems....

[David]

I forgot about this one, but I know from previous experience that it can work wonders. :)

[mikedippel]

To enter the usa.sql database, I logged in to my server root directory and created a directory called data. I then created a file called insert.sh

The contents of the insert.sh file are below.

#!/bin/sh
#
DB_NAME=regional
Mysql_file=usa.sql

# at prompt type MySQL root password
echo "At prompt below type MySQL root password"
echo "This is not the same as root password for the computer"

mysql --user=root --password --database=$DB_NAME < $Mysql_file

# end

For this to work, you must have SSH access to your server and you must copy the usa.sql file to this /data directory and rename the DB_NAME from regional to whatever your database name is for your regional directory.

I did the same for the countries as well by changing the second line to:
Mysql_file=countries.txt

Hope this helps anyone who has not been able to import the database yet.

Check out my attempt ath this script:
http://regionaldirectory.biz

and feel free to enter your sites while you're there.

[David]

Thanks for your help.
Your site is looking good, and off to a great start! :)

[fworth]

Hi, do you have the download to The USA database???

[anon]

I just had this serious urge to come into the thread to chant USA...USA...USA

hahaha sorry uk/euro peeps :p

[David]

I just sent it to someone.
Let me know if anyone else needs it.

[fworth]

I just sent it to someone.
Let me know if anyone else needs it.

Hey,David?

I need the data base..kindly send it asap?
Thanks! Lore