At 22:24 -0700 2001/12/04, René Fournier wrote: >The migration continues... > >Now I have to get my mysql database running under MySQL 3.23.46 on >OSX 10.1.1. I've dumped the structure and contents of the database >(on Windows) into a text file, and now I'd like to recreate it in >the new enivronment. I think I can use the mysql admin tools via >command line (but really, what is the syntax for piping a 'dumped' >database into a new database? "mysqladmin create database < >dumpeddb.sql"??), but one question about users...
Allo René, Depending on the command you used to dump the data, the table creation commands will already be in the mysqldump file. You can look at it with a text editor. Your guess was almost right. :> To bring the dump into your new database, just do: mysql database_name -p < backup_file.sql The '-p' will prompt for your password. There's a bunch of good info in the manual about this. Check out "4.8.5 mysqldump, Dumping Table Structure and Data." >I have to create a MySQL for my PHP scripts. How do I do this in Mac >OSX? There are a bunch of command line tools, but I'm not sure which >one[s] to use. Not sure I understand this question. What do you mean by "create a MySQL for my PHP?" >Thanks. > >...Rene Hope this helps, /Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] "Life's unfair - but root password helps!" --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
