Restoring data to a database

2001-05-18 Thread Don Pro
Hi, I back up my entire database with the following command: mysqldump --opt -ppassword mydbf_db /mydir/mydbf.backup Does anyone know the counterpart command to restore from the backup file? Thanks, Don - Before posting,

simultaneous connections

2001-05-11 Thread Don Pro
Hi, I'm reading in my documentation (I have a book) that MySQL allows up to 101 simultaneous connections. Gadzooks! How can MySQL claim to be at the Enterprise level with this limit? Is there any way around this? Thanks, Don

Do I need to locak a file when foind a SELECT?

2001-05-07 Thread Don Pro
Hi, As the subject states, I am getting an error in my Perl script telling me that a table is not locked yet all I am doing is a SELECT. Why do I need lock a table in order to issue a SELECT? The code in question is: $sqlCmd = $dbh-prepare(q{ SELECT Booking FROM Bookings where