Import Database from MySQL3.x to MySQL 4.x

2003-08-14 Thread Mario Ohnewald
Hello! I want to import a MySQL 3.x Databse to my new shiny MySQL4.x. I did a backup with /usr/local/mysql-standard-4.0.14-pc-linux-i686/bin/mysqldump -u root -p --opt -A mysql_lamp_backup.`date '+%Y.%m.%d'`.sql And i tried to import it to MySQL4.x with: /usr/local/mysql/bin/mysql -u root -p

mysql_query

2002-09-24 Thread Mario Ohnewald
Hello! I am a bloody newbie in this whole mysql area, so please forgive me for such a silly question ;) I have expected to get the text from the field with this code. $result=MYSQL_QUERY( SELECT mail_1 FROM table_mail WHERE rechner_nr='Rechner1'); echo $result; As result i get: Resource id #2

RE: mysql_query

2002-09-24 Thread Mario Ohnewald
Great, thanks a lot! From: Henk Huizinga [mailto:[EMAIL PROTECTED]] Mario, This is actually an PHP question. You forgot the following code : $resultquery = mysql_fetch_row($result); echo $resultquery[0]; Cheers, Henk -Original Message- From: Mario Ohnewald [mailto

Forgot mysql-root password

2002-09-18 Thread Mario Ohnewald
Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting

Forgot Mysql-Root Password

2002-09-18 Thread Mario Ohnewald
Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting

RE: Forgot mysql-root password

2002-09-18 Thread Mario Ohnewald
AH..thx a lot everybody! -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 18. September 2002 15:34 To: [EMAIL PROTECTED] Subject: re: Forgot mysql-root password Mario, Wednesday, September 18, 2002, 1:50:25 PM, you wrote: MO I am using