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 <

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 a

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

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 > >