To backup tables in MySQL, you can also use the sql query "backup table <tablename> to '<directory name>' " This query will copy the .frm and .MYD files to <directory name>. Remember that this directory should be writable by the mysql user. To restore the backup, you can use "restore table <tablename> from '<directoryname>' " This query will recreate the .MYI file.
This is much faster than mysqldump, and very effective incase of a huge production database. Regards Subhasis On 2/28/06, Gaurav Mishra <[EMAIL PROTECTED]> wrote: > > On 2/28/06, ankit walia <[EMAIL PROTECTED]> wrote: > > hi all, > > i hv a file in which all the queries r written i want 2 use this file. > > using this command mysqldump datbasename > filename > > mysql databasename < filename , the above redirectional command is to > load the aql queries... > > this command is executing but no table is created plz help > > ur suggestions can b treasure for me > > thanks > > > btw, u could try mysql-admin a gui package for all mysql works > on ubuntu it`s simple sudo apt-get mysql-admin , for rest > google urself...........:) > -- > "When i can run , i will run , When i can walk , i will walk, When i > can crawl , i will crawl. But i will not stop moving forward" > Linux User #348873 > http://rockybhai.blogspot.com > _______________________________________________ > ilugd mailinglist -- ilugd@lists.linux-delhi.org > http://frodo.hserus.net/mailman/listinfo/ilugd > Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi > http://www.mail-archive.com/ilugd@lists.linux-delhi.org/ > > _______________________________________________ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/
