hi, thanks for the info. I'm not very sure about mysql. but this is what ive got.
ive got three tables with data in it.need to save the tables and run it on another machine or rather view the tables and records in another machine. 1. if i use mysqldump query, it will prepare a backup right? and where does is prepare it into??? 2. will all the records also be transfered or only the table structure?? 3. will anything get deleted from my machine where the tables are orignally present?? how to go about mysqldump?? Liz Quoting zzapper <[EMAIL PROTECTED]>: > On Tue, 27 Apr 2004 17:06:59 -0400 (EDT), wrote: > > >hi, > > i have mysql on my local machine.and i have created tables in my > database. > >if i need to copy these tables onto a cd and transfer them , which > folder to i > >copy? is it the data directory under mysql??? > > > >i am not sure abt this. > > > >Thanks, > >liz > > Liz, You can do this, but I'd rather store them as a script eg with > mysqldump > > > zzapper (vim, cygwin, wiki & zsh) > -- > > vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" > > http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
