lets try it: - first, create database : dbase_name and type it: % mysql -uusername -ppassword dbase_name < /path/to/directory/yourdump.sql
if anything wrong, please check yourdump.sql. May be incorrect syntax. ----- Original Message ----- From: "kk" <[EMAIL PROTECTED]> Date: Fri, 14 Feb 2003 17:10:28 +0900 To: "list mysql" <[EMAIL PROTECTED]> Subject: Re: My dump does not work > When I faced the same problem, I was suggested to use MySQL Front. I have > been also using phpMyAdmin.Both work fine. > > Hope this will help u > > regards > ----- Original Message ----- > From: "srinath sundarrajan" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 14, 2003 4:11 PM > Subject: My dump does not work > > > > Hello, > > > > I face a problem in transfering a mysql db from 1 machine to another. I > used > > the mysqldump command to take the dump of a db from machine A running > linux. > > I put the same on to a machine B running on linux. Then I used the > mysqldump > > command to create the database. In all 15 tables should be there. > > Unfortunately only 3 tabels are there. The dump restoration stops midway > > through the third table without giving any error. I tried opening the > > original .sql file in wordpad. All the tabels & records are there. Any > idea > > what could be the problem. Is there any way to transfer table by table. > > Machine B is a new one. > > > > Thanks & regards, > > Srinivasan. > > > > _________________________________________________________________ > > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > > http://join.msn.com/?page=features/junkmail > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > --------------------------------------------------------------------- > 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 > -- __________________________________________________________ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup --------------------------------------------------------------------- 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
