Undefined variable: authed

2005-08-06 Thread Trevor Tregoweth
Hi There I am trying to run a simple password /php / mysql script for a web page and get the following errors, it works fine on a earlier versions of php / mysql PHP Notice: Undefined variable: help_out_uid in /var/www/html/lcc/secure/secure.php on line 87, PHP Notice: Undefined variable: aut

Populating table with test file

2005-08-06 Thread Jeff Broomall
Hello. I'm creating my first database and would prefer populating the tables using a text file I'll create in Notepad (not that it makes and difference). In case it matters, I'm using myPHPadmin provided by my web hosting service. I'm a little confused about the format of the data in the text

RE: how do i solve this problem?

2005-08-06 Thread yousef albarak
hello peter, I used this command to dump the data bases mysqldump -u root -p [database] > [filename.sql] and for restoring i used mysql -uUSERNAME -p newdbname < /path/to/dump.sql with all databases i got this kind of errors in different lines: ERROR 1062 (23000) at line 377726: Duplicate Entry

RE: how do i solve this problem?

2005-08-06 Thread Peter Normann
Sounds like you are trying to import records already present on server B. You might want to add drop table in your dump... Something like: mysqldump --complete-insert --extended-insert --add-drop-table Peter Normann yousef albarak wrote: > hi, > I am try to restore many databases from server

how do i solve this problem?

2005-08-06 Thread yousef albarak
hi, I am try to restore many databases from server A to server B,but when with every database i got this error(s) mysql error: Duplicate entry '65535' for key 1 mysql error number: 1062 It happen with all databases in different lines. Is there any solution for this errors? Regards, Yousef _

Implication and usage of character sets for i18n data (?)

2005-08-06 Thread Maxim Vexler
Hello to each and every one of you. I'm wondering about the practical effect of character sets in mysql 4.0 & 4.1 as follows. What is it good for? Assuming I'm storing text data uin windows-hebrew (1255) codepage, to be used by my php application. I can have my database & table to be defined a

Daily maintenance for mysql

2005-08-06 Thread JM
Hi, Im still new to mysql and Im the processes of reading the manual. Since I need a quick answer I need inputs on things to do to maintain the DB. Is there a similar pg_dump thing? or it doesn't need it? tia, -- MySQL General Mailing List For list archives: http://lists.my