Re: [PHP] Mac OSX and MySQL
As soon as the mysqld is running (and PHP also of course), you can use phpMyAdmin to set up new tables. If you are not experienced in CLI it's a nice way to go avoiding the CLI as far as possible (IMHO). Get a look at those pages: www.macosx.org www.stepwise.com best regards Stefan Rusterholz, [EMAIL PROTECTED] -- interaktion gmbh Stefan Rusterholz Zürichbergstrasse 17 8032 Zürich -- T. +41 1 253 19 55 F. +41 1 253 19 56 W3 www.interaktion.ch -- - Original Message - From: René Fournier [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, December 05, 2001 6:24 AM Subject: [PHP] Mac OSX and MySQL 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... 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. Thanks. ...Rene --- René Fournier [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Mac OSX and MySQL
On Wednesday, December 5, 2001, at 12:24 AM, René Fournier wrote: 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. Well, if you already have MySQL installed, then just use them as normal. Just remember that Unix syntax is different from DOS (lets you do more, actually). If you need to install MySQL, try these: http://developer.apple.com/internet/macosx/osdb.html the above link is for Apple's own recommendations for installing MySQL on Darwin. Just make sure that you use the source code for 3.23.45, not 3.43.44 (because the .44 doesn't shut down properly in Darwin). I used this technique (not the binary) and it works great. http://fink.sourceforge.net if you use Fink (debian-style package installer) you can have it install MySQL for you (as well as PHP and Apache) but I didn't go this route because I wanted more control over the install process. http://www.stepwise.com/Articles/Workbench/2001-10-11.01.html the above link isn't for MySQL at all, it's for PHP, but it's a useful article. Remember to add the --with-mysql configure option because this tutorial doesn't assume that you want to install MySQL. Any questions, email me. Erik -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Mac OSX and MySQL
On Wed, 5 Dec 2001 15:54, 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... Two steps involved - create the database, then dump the data into it. mysqladmin create database mysql database dumpeddb.sql ObNitpick - that is a redirect, not a pipe. 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. I don't understand? -- David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA Friends come and go, enemies accumulate. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Mac OSX and MySQL
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... 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. Thanks. ...Rene --- René Fournier [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]