hello erveryone, I have a question about mysqldump.I have some blob data,
someone tell me mysqldump the data must use "hex-blob" options, why?
Warning: Can't create database 'spreadsheets'; database exists
This is the answer.
2009/8/24 Victor Subervi
> Hi,
> I have the following python code:
>
> cursor.execute('create database if not exists spreadsheets;')
> cursor.execute('use spreadsheets;')
>
> but it generates this warning:
>
>
you also can do this:#sudo -u mysql "mysqldump command"
or
#su - mysql -c "mysqldump command"
2009/7/24 walter harms
>
>
> muhammad subair schrieb:
> > On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote:
> >
> >> Hi list,
> >> i use mysqldump --tab to create database dumps. this will prod
# chown mysql.mysql datafile
2009/7/23 walter harms
> Hi list,
> i use mysqldump --tab to create database dumps. this will produce txt and
> sql files.
> the resulting sql files is owned by the user but the resulting datafile is
> owned by mysql.mysql
> is there any way to change that ?
>
> r
#mysqldump -u username -p -h mysqld_host databasename > database_name.sql
username is the mysqld server login name
mysqld_host is the mysqld server address or hostname
databasename is the database which you should dump
You can use "man mysqldump" or "mysqldump --help" to get more infomation
2009/
