Try removing the space between -p and password. i.e., like this:
mysqldump databasename -u username -ppassword >/to/a/directory/dump.sql
> Hello
>
> I'm trying to make mysqldump in a shell script but I can't deliver
> password to sql server.
>
> I have command in the script:
>
> mysqldump data
I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
go from the version that came with the distro (version 3.23.54) to the
latest (verion 4.0).
Just thought I'd post to get a heads-up on any known issues or
prerequisites. I just hate it when I try something like this and screw
Well, the easiest thing is to "escape" any single quotes with a backslash
character (\). PHP includes a function named addslashes() that does this.
http://us4.php.net/manual/en/function.addslashes.php
Same logic applies in other languages.
Hope this helps.
Andrew
> Help! I'm trying to do an
I have a question regarding compiling a C program with the mysql C api.
>From the documentation, the only way I really see explained for compiling
is a shell script that looks like this:
CFG=/usr/bin/mysql_config
sh -c "gcc -o $1 `$CFG --cflags` $1.c `$CFG --libs`"
This works great when all my so
Andrew
> At 20:37 -0400 6/18/03, Andrew Pierce wrote:
>>I am trying to learn to use the C API for MySQL and have a question. I
>> have a table that has a primary key defined as int(11). I don't know
>> what data type this translates to in C. I thought maybe an unsigned int
I am trying to learn to use the C API for MySQL and have a question. I
have a table that has a primary key defined as int(11). I don't know what
data type this translates to in C. I thought maybe an unsigned int or an
unsigned long. I have this little loop that cycles through the results of
a query
gt; Andrew try this:
>
> grant all privileges on *.*
> to 'amp'@'%'
> identified by 'blah'
> (with grant option)
> ;
>
> let me know if it works.
>
> ----- Original Message -
> From: "Matt Hargraves" <[EMAIL PROTECTED]>
>
I have a new installation of RedHat 7.3 and MySql. I had MySql working
great on a Mandrake 8.0 installation. Now that I have reloaded this box
with RH, I cannot get setup and working.
I can run mysql as root and get in. I ran the commands below:
>grant all on * to amp identified by 'blahdblah';
