> I have a text file with all my database information > from creating databases to setting up tables. I have > looked throught the mysql docs on how to load these on > from a text file via the mysql prompt. But all I can > find is: > > load data infile "filename.txt" into table whatever > > But this is not what I am looking for. :( As the > tables are already defined in the text file and the > appropiate database name to enter them into. > > Is there a way to load these into the database > directly instead of doing each table seperately from > the mysql prompt? (not web admin) Is this a mysqldump file? The file has all of the SQL statements that you need to run? If so, just send it to mysql... Mysql -uuser -ppassword database_name < filename.txt You can call that through exec() if you want. The file must be proper SQL, though. ---John W. Holmes... Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
