Restoring data to a database

2001-05-18 Thread Don Pro
Hi, I back up my entire database with the following command: mysqldump --opt -p"password" 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