Re: off-line development tool?
No need, Marco. Assuming you can run Mysql at the remote machine, you can simply take the export file and run it in mysql. Either, from the mysql prompt, type mysql use mynewdatabase; mysql source dumpfile; or you can do it from a command line like % mysql -e use mynewdatabase; source dumpfile; Hope that was what you wanted... steve On Sunday 24 February 2002 12:31 am, Marco Bleeker wrote: If I rember well MySQLdump is a utility. I can run that at my local machine, but how to do the reverse thing at the remote machine. I can't run much more than HTML and PHP scripts there. Is there a tool that can convert the MySQLdump export file into something that looks like a PHP script and that I could unleash a CREATE command on? - 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
off-line development tool?
Marco, Saturday, February 23, 2002, 3:59:20 AM, you wrote: MB Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a MB remote hosting server, and I have only limited access to the database at MB that server. I want to populate my database off-line at my home machine, and MB then upload the whole thing (100s of lengthy entries) to the server. But I MB don't have direct access there. So I suppose I'll have to do something like MB exporting my data to a text file, upload the text file to the root of my MB domain at the server and re-create the database from there. I don't think I MB can run any tool on the server; I work with .php files there. MB So my question is: how would people normally go about this task. Would I MB need to write a script for in- and export of data, or would there perhaps be MB a handy tool that takes this out of my hands? mysqldump will help you, see at: http://www.mysql.com/doc/m/y/mysqldump.html Look at SELECT ... INTO OUTFILE info in the manual: http://www.mysql.com/doc/S/E/SELECT.html MB Thanks, Marco Bleeker, Amsterdam -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
RE: off-line development tool?
If I rember well MySQLdump is a utility. I can run that at my local machine, but how to do the reverse thing at the remote machine. I can't run much more than HTML and PHP scripts there. Is there a tool that can convert the MySQLdump export file into something that looks like a PHP script and that I could unleash a CREATE command on? Thanks, Marco From: Eric Mayers [EMAIL PROTECTED] To: Marco Bleeker [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: off-line development tool? Date: Fri, 22 Feb 2002 18:27:23 -0800 I suggest you install a MySQL Database on a local machine and do development there. When you want to push this stuff to the remote machine use mysqldump to pull the contents out of the local database. I don't think it would be appropriate for this but you might consider database replication if you want it to be a more automatic process. Eric Mayers Software Engineer I Captus Networks -Original Message- From: Marco Bleeker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 5:59 PM To: [EMAIL PROTECTED] Subject: off-line development tool? Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a remote hosting server, and I have only limited access to the database at that server. I want to populate my database off-line at my home machine, and then upload the whole thing (100s of lengthy entries) to the server. But I don't have direct access there. So I suppose I'll have to do something like exporting my data to a text file, upload the text file to the root of my domain at the server and re-create the database from there. I don't think I can run any tool on the server; I work with .php files there. So my question is: how would people normally go about this task. Would I need to write a script for in- and export of data, or would there perhaps be a handy tool that takes this out of my hands? Thanks, Marco Bleeker, Amsterdam _ MSN Foto's is de eenvoudigste manier om je foto's te delen en af te drukken: http://photos.msn.nl/Support/WorldWide.aspx - 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 Marco Bleeker, Amsterdam _ Download MSN Explorer gratis van http://explorer.msn.nl/intl.asp. - 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
off-line development tool?
Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a remote hosting server, and I have only limited access to the database at that server. I want to populate my database off-line at my home machine, and then upload the whole thing (100s of lengthy entries) to the server. But I don't have direct access there. So I suppose I'll have to do something like exporting my data to a text file, upload the text file to the root of my domain at the server and re-create the database from there. I don't think I can run any tool on the server; I work with .php files there. So my question is: how would people normally go about this task. Would I need to write a script for in- and export of data, or would there perhaps be a handy tool that takes this out of my hands? Thanks, Marco Bleeker, Amsterdam _ MSN Foto's is de eenvoudigste manier om je foto's te delen en af te drukken: http://photos.msn.nl/Support/WorldWide.aspx - 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
RE: off-line development tool?
I suggest you install a MySQL Database on a local machine and do development there. When you want to push this stuff to the remote machine use mysqldump to pull the contents out of the local database. I don't think it would be appropriate for this but you might consider database replication if you want it to be a more automatic process. Eric Mayers Software Engineer I Captus Networks -Original Message- From: Marco Bleeker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 5:59 PM To: [EMAIL PROTECTED] Subject: off-line development tool? Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a remote hosting server, and I have only limited access to the database at that server. I want to populate my database off-line at my home machine, and then upload the whole thing (100s of lengthy entries) to the server. But I don't have direct access there. So I suppose I'll have to do something like exporting my data to a text file, upload the text file to the root of my domain at the server and re-create the database from there. I don't think I can run any tool on the server; I work with .php files there. So my question is: how would people normally go about this task. Would I need to write a script for in- and export of data, or would there perhaps be a handy tool that takes this out of my hands? Thanks, Marco Bleeker, Amsterdam _ MSN Foto's is de eenvoudigste manier om je foto's te delen en af te drukken: http://photos.msn.nl/Support/WorldWide.aspx - 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