re: Exporting Data via Command Line
Hello Guys, I am a newbie to mySQL and im trying to export my database via the mySQL Command line but i cant seem to find any good documentation on how to do this. More articles are telling me to use phpAdmin or some other gui tool. I would like to learn the commands anyone has a good doc on this? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Exporting Data via Command Line
http://www.mysql.com would be a nice place to start. On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive [EMAIL PROTECTED] wrote: Hello Guys, I am a newbie to mySQL and im trying to export my database via the mySQL Command line but i cant seem to find any good documentation on how to do this. More articles are telling me to use phpAdmin or some other gui tool. I would like to learn the commands anyone has a good doc on this? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Power to people, Linux is here. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Exporting Data via Command Line
run: mysqldump --help On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive [EMAIL PROTECTED] wrote: Hello Guys, I am a newbie to mySQL and im trying to export my database via the mySQL Command line but i cant seem to find any good documentation on how to do this. More articles are telling me to use phpAdmin or some other gui tool. I would like to learn the commands anyone has a good doc on this? Thanks -- 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]
Re: Exporting Data via Command Line
i'll usually pipe mysqldump into gzip if it's a large database, or gpg if there's sensitive data in it. -jacob On Fri, 4 Mar 2005 12:22:08 -0600, jacob martinson [EMAIL PROTECTED] wrote: run: mysqldump --help On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive [EMAIL PROTECTED] wrote: Hello Guys, I am a newbie to mySQL and im trying to export my database via the mySQL Command line but i cant seem to find any good documentation on how to do this. More articles are telling me to use phpAdmin or some other gui tool. I would like to learn the commands anyone has a good doc on this? Thanks -- 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]
re: Exporting Data via Command Line
MrExecutive [EMAIL PROTECTED] wrote on 03/04/2005 01:12:02 PM: Hello Guys, I am a newbie to mySQL and im trying to export my database via the mySQL Command line but i cant seem to find any good documentation on how to do this. More articles are telling me to use phpAdmin or some other gui tool. I would like to learn the commands anyone has a good doc on this? Thanks Try reading up on these commands: (from a command shell prompt) mysqldump http://dev.mysql.com/doc/mysql/en/mysqldump.html (from within a MySQL client) SELECT ... INTO OUTFILE http://dev.mysql.com/doc/mysql/en/select.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Exporting Data via Command Line
Lets not forget about mysqlhotcopy. -Eric On Fri, 4 Mar 2005 13:42:48 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: MrExecutive [EMAIL PROTECTED] wrote on 03/04/2005 01:12:02 PM: Hello Guys, I am a newbie to mySQL and im trying to export my database via the mySQL Command line but i cant seem to find any good documentation on how to do this. More articles are telling me to use phpAdmin or some other gui tool. I would like to learn the commands anyone has a good doc on this? Thanks Try reading up on these commands: (from a command shell prompt) mysqldump http://dev.mysql.com/doc/mysql/en/mysqldump.html (from within a MySQL client) SELECT ... INTO OUTFILE http://dev.mysql.com/doc/mysql/en/select.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]