Re: [PHP] Dumped OK, Restore NOT

2001-12-05 Thread René Fournier
You know, I tried that, it it STILL didn't work. Then, after remembering to reboot my brain, I took a look at the smarts.sql that my ISP kindly dumped for me, to see what code/statements it might be missing--and lo and behold!--it didn't have a USE database; statement! Adding this one wee line

RE: [PHP] Dumped OK, Restore NOT

2001-12-05 Thread Jon Haworth
> Anyways, if any PHP people here are--god forbid--actually using MySQL as > their database, I would GREATLY appreciate any help in this matter. I've > thoroughly read the mysqldump chapter in the docs, and gone through > several tutorials, but have found nothing on actually restoring a > data

Re: [PHP] Dumped OK, Restore NOT

2001-12-05 Thread René Fournier
That's why I cross-posted there as well. But I've found that posting to the mysql list doesn't help, more often than not--perhaps fewer subscribers. Anyways, if any PHP people here are--god forbid--actually using MySQL as their database, I would GREATLY appreciate any help in this matter. I've

Dumped OK, Restore NOT

2001-12-05 Thread René Fournier
Little problem with MySQL 3.23.46 under Windows ME. I'm trying to create a database from an .sql file (the dumped remains of a functioning database--also MySQL). The dumping was easy, but I'm having a problem putting it back. I have a dumped file called smarts.sql that starts this way: ---