On Friday 09 April 2004 12:26 pm, Mark Susol | Ultimate Creative Media wrote: > Ok now I want to "dump" tables with names starting with "phpads" so I can > move them to another db. How is the mysqldump command run then? > > And when I go to move them to the new db, I do use the mysqldump command > since I am dumping to the new db? > > Mark
/var/lib/mysql/ holds all of your DB's. Inside each directory(DB) there are 3 files for each table in that DB (assuming myisam here). You can copy these files to the from one server to the next. It's probably a good idea to stop the servers during this process so that no one can alter the table or try to read from it while you are replacing the old with the new. I don't know that mysqldump takes wildcards so to use that you will probably have to do an individual mysqldump for each table in the DB that you want to dump. Type in man mysqldump to see all the options for mysqldump. James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]