how do you import a mysql db that is 114mb?

S

smbsystem

Verified User
Joined
Feb 10, 2006
Messages
7
i got a client who have a mysql db over 114mb with 10 table and he have it save as "example-db.sql.gz" which is 14mb. i try the phpmyadmin in DA but i think it only limited to 2mb. how do i import big db into mysql with phpmyadmin or my only option is to login to the server and inject it(?) from within the server? i'm running FreeBSD 5.3.

can someone show me a linke or tell me how to import over 2mb mysql db with phpmyadmin?

thank you
 
You would have to modify the php.ini to increase the limit, but with that filesize I wouldn't waste the time.

I would ftp the backup to the site, extract it, and import it to MySQL through the command line.
 
I copy where and you might want to test it out.

Similarly, to restore a database from a dump file, please do the following command.

mysql -uu777_database -pPASSWORD \
u777_database < u777_database.sql

To do the same but with a gzip compressed dump file, do the following instead of the above.

gunzip < u777_database.sql.gz | \
mysql -uu777_database -pPASSWORD \
u777_database
 
dannygoh said:
I copy where and you might want to test it out.

Similarly, to restore a database from a dump file, please do the following command.

mysql -uu777_database -pPASSWORD \
u777_database < u777_database.sql

To do the same but with a gzip compressed dump file, do the following instead of the above.

gunzip < u777_database.sql.gz | \
mysql -uu777_database -pPASSWORD \
u777_database
Click to expand...

hello so for gzip compressed dump file,

i do gunzip < exampledb.sql.gz | \ mysql -exampledb -pPASSWORD\ exampledb

am i correct?

i don't quite understand the -uu777 is that the command then the database like -uu777_exampledb.sql.gz

thank you
 
This is a three line command.

Code: 
gunzip < u777_database.sql.gz | \
mysql -uu777_database -pPASSWORD \
u777_database

-u follow by the username (eg. -uda_admin)
-p follow by the password.
 
i got the db imported but here is another problem

: It's in the wrong language. The 'collation' [that is, the language set used] is Latin1-Swedish-ci but it should be ISO8859-1. With our database expecting ISO8859-1, it is spewing out garbled feeds, because it thinks the server is Swedish language set, and it is English language of course. If the collation can be rectified to ISO8859-1 then we are done! So close!


does anyone have any idea on how to fix this problem?
 
my customer's mysql db is MySQL 4.0.25-standard imported to the mysql 4.1

how do i solve this lanaugae character set problem?
 
I think you can change it through phpMyAdmin. On the Operations page, look for Collation. I haven't tried it though.
 
jmstacey said:
I think you can change it through phpMyAdmin. On the Operations page, look for Collation. I haven't tried it though.
Click to expand...

yeah, you can set it with phpmyadmin but here is his reply

"knows how to do that but there is no ISO8859-1 [which, in the English speaking world is the ONLY language set you can use!]"

i check mysql manaul http://dev.mysql.com/doc/refman/4.1/en/charset-map.html

on 10.9.1. 4.0 Character Sets and Corresponding 4.1 Character Set/Collation Pairs

there is no character set that is corresponding to ISO8859-1.

what exactly is ISO8859-1?
 
You've got the right collation, but the problem comes from moving from a 4.0 mysql to a 4.1 one.

Try reading some doc or the forums at mysql.com, I think there are examples of conversion between the two.
 
Not so big..just ssh in the server...

mysql DB -uDBUSER -pPASSWORD < DB.sql

Just for the same MYSQL release..If not the same... you can contect me
 
You must log in or register to reply here.
Back
Top