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
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
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
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
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
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
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
Hi!
Trying to figure out mysqldump. How would i type to making a backup of a
database with specific username and password with mysqldump?
I've tryed making a backup-schema through MySQL Administrator but there it
says... Wrong password. I've changed the password type to Obscure but it
doesn'
You need to select the Database either in your script or via command line.
If you're doing it via the command line, it would be this:
use dbname
where dbname is the name of your database. If you're using a script, drop
this in:
$db = mysql_connect("$host", "$user","$pass");
mysql_select_db("$db
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
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
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:
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
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
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 choosing the file I want to upload i got this
error, any help will be appreciated.
Giro
Error
SQL-quer
15 matches
Mail list logo
