Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Empty string is not NOT NULL?
This is ANSI standard SQL behaviour, NULL has a specific meaning, not the same as empty! As the MySQL docs say ... The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that NULL is the same thing as an empty string "". This is not the... -
Error 1045 with "BACKUP TABLE tbl_name TO '/path/to/backup/directory'"
Problem solved! Turns out to be a wierd php problem, not MySQL at all. If you're interested, the solution was to not connect to the db using a function, but to connect (mysql_pconnect/mysql_select_db) in the actual script. Same code, just doesn't work if it's executed in a function. Wierd... -
Error 1045 with "BACKUP TABLE tbl_name TO '/path/to/backup/directory'"
I have developed a PHP/MySQL driven website, and I want the site administrator to be able to back the db up when they want. It's all running on a hosting service. The solution I came up with was when the administrator requests a backup: 1) create a new directory with name=timestamp 2) for each...
