how to import large database in mysql?

Question

I have 1000 no of email in a text document. My database table has two fields namely "ID" and "email" where id is auto increment. Now i want to import the 1000 email to email field in the database. Therefore the table has 1000 rows. How to do it. Please help me...

Answer 1

You can import just any file in mysql database



Better if you make it Comma Seprated Value (CSV) and import it to mysql in table

heres the command

mysqlimport [options] db_name textfile1 [textfile2 ...]



Further details available at

http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html





Hope this helps

Cheers:)

Answer 2

i've got self assurance you are able to upload a csv record applying gadget like phpMyAdmin. right this is what I in many circumstances do. as an occasion, if i could desire to pass content fabric from database A to database B, i exploit mysqldump from command line like this: mysqldump databaseA > a.sq. then i will load it into B: mysql databaseB < a.sq. The instructions above are in basic terms examples and you in addition to mght could desire to offer arguments like person call and password.

Answer 3

http://dev.mysql.com/doc/