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
