Re: [PHP] Dumped OK, Restore NOT
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 thoroughly read the mysqldump chapter in the docs, and gone through several tutorials, but have found nothing on actually restoring a database from a dumped file--ON Windows. On Wednesday, December 5, 2001, at 09:49 AM, Kurt Lieber wrote: On Wednesday 05 December 2001 08:02 am, you wrote: Little problem with MySQL 3.23.46 under Windows ME. I This would be an excellent question for the MySQL mailing list. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- René Fournier [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Dumped OK, Restore NOT
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 database from a dumped file--ON Windows. Have you tried something like phpMyAdmin (or something similar, like Mascon)? Cheers Jon ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Dumped OK, Restore NOT
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 made all the difference in the world. Your suggestions(s) work; I can now restore my database locally. Thanks everyone for your help and patience! (And my apologies for posting off-topic oh PHP--I've been suitably chastised, and will remember to name the subject OT: next time I feel tempted to ignore netiquette.) ...Rene On Wednesday, December 5, 2001, at 10:56 AM, Ernesto wrote: You should try: mysql -u username -p password database dump.sql Example: mysql -u joe -p mypass smarts smarts.sql René Fournier wrote: 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: - # MySQL dump 8.14 # # Host: localhostDatabase: smarts # # Server version3.23.38 # # Table structure for table 'about' # CREATE TABLE about ( id smallint(5) unsigned NOT NULL auto_increment, lang char(2) default NULL, recordname varchar(40) default NULL, key1 tinytext, key2 tinytext, status varchar(10) default NULL, title tinytext, par1 tinytext, PRIMARY KEY (id) ) TYPE=MyISAM; # # Dumping data for table 'about' # INSERT INTO about VALUES (1,'en','about' ---(and so on) This is what I'm doing to try to recreate the database locally: 1. I type mysqladmin create smarts OK--I see a new directory called smarts (no files in it) 2. I type mysql smarts smarts.sql It pauses for a few seconds (seeming to input the file), then returns the DOS prompt with no message, error or otherwise. Seems to have worked, right? But when I check the 'smarts' database directory, there are no files in it. (Incidentally mysqld is running.) What am I doing wrong?? ...Rene --- René Fournier [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
