mysqldump hex-blob option

[peng yao]

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?

Re: Suppressing Warnings

[peng yao]

Warning: Can't create database 'spreadsheets'; database exists

This is the answer.

2009/8/24 Victor Subervi victorsube...@gmail.com

 Hi,
 I have the following python code:

  cursor.execute('create database if not exists spreadsheets;')
  cursor.execute('use spreadsheets;')

 but it generates this warning:

 Warning (from warnings module):
  File C:\Python25\mysqlConverter.py, line 140
cursor.execute('use spreadsheets;')
 Warning: Can't create database 'spreadsheets'; database exists

 What do?
 TIA,
 Victor

Re: mysqldump and access rights

[peng yao]

you also can do this:#sudo -u mysql mysqldump command
or
#su - mysql -c mysqldump command



2009/7/24 walter harms wha...@bfs.de



 muhammad subair schrieb:
  On Thu, Jul 23, 2009 at 10:10 PM, walter harms wha...@bfs.de wrote:
 
  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 ?
 
  re.
   wh
 
  -
 
 
  Hi, you can use this in Linux
 
  *# chown user:user /path/to/file.txt*
 

 hi,
  yes i am aware of that but it would be more helpful for me if
  mysqldump uses the right ownership in the first place.

 re,
  wh




 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql?unsub=xwei...@gmail.com

Re: mysqldump output

[peng yao]

#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/7/21 zhu dingze mysql.li...@gmail.com

 we need more information,
 such as your client and server version, the command that exactly your input
 etc.

 2009/7/14 JingTian jingtian.seu...@gmail.com

  hi all,
 
  i use mysqldump to backup my database,
  the command line is; mysqldump -p -u -h database_name  database_name.sql
 
  i find in the database_name.sql, there is a line:
  Not dumping tablespaces as no INFORMATION_SCHEMA.FILES table on this
 server
 
  can anyone tell me what does it mean?
 
  thanks very much,
  --
  Tianjing
 



 --
 Dingze Zhu

 We are running the best Chinese MySQL and Solaris Community in China.
 Welcome to visit http://www.mysqlsystems.com

Re: mysqldump and access rights

[peng yao]

# chown mysql.mysql  datafile

2009/7/23 walter harms wha...@bfs.de

 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 ?

 re.
  wh

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql?unsub=xwei...@gmail.com