RE: [PHP-WIN] MySQL Dump

2007-05-14 Thread Gustav Wiberg
Hi! Ok... Thanx! Best regards /Gustav Wiberg -Original Message- From: Mikael Grön [mailto:[EMAIL PROTECTED] Sent: Monday, May 14, 2007 1:41 PM To: ''php windows' (php-windows@lists.php.net)' Subject: Re: [PHP-WIN] MySQL Dump Oh yeah, of course. :) Mike Gusta

Re: [PHP-WIN] MySQL Dump

2007-05-14 Thread Mikael Grön
s@lists.php.net)' Subject: Re: [PHP-WIN] MySQL Dump mysqldump -uusername -p -A > output.file Enter password: [password] Done Gustav Wiberg skrev: Hi there! Thanx! Does this mean that I can't use option -ALL databases when using usernames and passwords? (I want to create a

RE: [PHP-WIN] MySQL Dump

2007-05-14 Thread Gustav Wiberg
Hi there! Username and password for root (for all databases then) you mean? /Gustav -Original Message- From: Mikael Grön [mailto:[EMAIL PROTECTED] Sent: Monday, May 14, 2007 1:32 PM To: ''php windows' (php-windows@lists.php.net)' Subject: Re: [PHP-WIN] M

Re: [PHP-WIN] MySQL Dump

2007-05-14 Thread Mikael Grön
Best regards /Gustav Wiberg -Original Message- From: Mikael Grön [mailto:[EMAIL PROTECTED] Sent: Monday, May 14, 2007 11:49 AM To: 'php windows' (php-windows@lists.php.net) Subject: Re: [PHP-WIN] MySQL Dump mysqldump -uusername -ppassword database > output.file or my

RE: [PHP-WIN] MySQL Dump

2007-05-14 Thread Gustav Wiberg
ECTED] Sent: Monday, May 14, 2007 11:49 AM To: 'php windows' (php-windows@lists.php.net) Subject: Re: [PHP-WIN] MySQL Dump mysqldump -uusername -ppassword database > output.file or mysqldump -uusername -p database > output.file which lets you specify the password cloaked right a

RE: [PHP-WIN] MySQL Dump

2007-05-14 Thread Gustav Wiberg
Hi there! Thanx. Does this mean that I have to this on each database if I want to create ba -Original Message- From: Mikael Grön [mailto:[EMAIL PROTECTED] Sent: Monday, May 14, 2007 11:49 AM To: 'php windows' (php-windows@lists.php.net) Subject: Re: [PHP-WIN] MySQL Dump

Re: [PHP-WIN] MySQL Dump

2007-05-14 Thread Mikael Grön
mysqldump -uusername -ppassword database > output.file or mysqldump -uusername -p database > output.file which lets you specify the password cloaked right after you've hit enter. Remember, no spaces between -u and the username or -p and the password. Mike Gustav Wiberg skrev: Hi! Trying to

Re: [PHP-WIN] mysql dump

2001-05-03 Thread Giro De Roover
OK I got it but it was painfull. In first place, I read somewhere that the latest release og phpMyadmin had fixes the backslash story and it is not true There is no way of having working now. In first place phpmyadmin keeps referring to a .TMP files which I haven't choose and don't even exist. T

Re: [PHP-WIN] mysql dump

2001-05-03 Thread Giro De Roover
sorry to be so clueless, but i tried as you mentioned and the page reload itseld like i am doing a reset (form type) and nothing happen. let me give you more explanation where i am: I am using phpmyadmin, i go to the table i want to load the data, then i click on "insert textfile into data" There

Re: [PHP-WIN] mysql dump

2001-05-03 Thread Johan Lundqvist
Sorry if I was a bit fuzzy... You have to escape out the "\" by typing "\\", so in your exaple it would say: LOAD DATA LOCAL INFILE 'c:\\Windows\\Temp\\phpC021.TMP' INTO TABLE my_contact FIELDS TERMINATED BY ';' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n' Since you get the error:

Re: [PHP-WIN] mysql dump

2001-05-02 Thread Giro De Roover
How is that done and where ?? "Johan Lundqvist" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi Giro, > > You'll have to type c:\\Windows\\Temp\\phpC021.TMP > > /Johan > > Giro De Roover wrote: > > > > Hi everyone, > > > > I am experiencing problem with mysq

Re: [PHP-WIN] mysql dump

2001-05-02 Thread Johan Lundqvist
Hi Giro, You'll have to type c:\\Windows\\Temp\\phpC021.TMP /Johan Giro De Roover wrote: > > Hi everyone, > > I am experiencing problem with mysql trying to import a text file with data > into a table, i am using phpmyadmin in order to do that, going to insert > textfiles into table and after