Re: INSERT encrypted data

s NULL instead of being encrypted. > sharif islam wrote: > > mysql> insert into ccard values(AES_ENCRYPT(123453535,'uiwuerw'),'10/2003'); > > Query OK, 1 row affected (0.00 sec) > > > > mysql> select * from ccard >

INSERT encrypted data

mysql> insert into ccard values(AES_ENCRYPT(123453535,'uiwuerw'),'10/2003'); Query OK, 1 row affected (0.00 sec) mysql> select * from ccard -> ; +--+-+ | crypt| expire | +--+-+ | )\u\u\u\u\u\u\u | 10/

Re: Mysql Backup/Dump

; > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://li

stopping server from pid file error

# mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/lib/mysql/mymachine.pid 050318 11:01:31 mysqld ended [EMAIL PROTECTED] mysql]# ls -la /var/lib/mysql total 40 drwxrwxr-x 4 mysql mysql 4096 Mar 18 10:54 . drwxr-xr-x 22 root root 4096 F

changing data dir

Do I have to reinstall mysql in order to change the default data dir from /var/lib/mysql? Can I do this: mv /var/lib/mysql /newdir/mysql cd /var/lib ln -s /newdir/mysql mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

spaces in table/column name

How mysql deals with spaces in table / column name? I am also using mysqlcc. If I try the following in the doesn't work. Creating table name with spaces from mysqlcc didn't give any error. But the following does: INSERT INTO 'tbl name with spaces' (col1, 'col name with spaces') VALUES(15,16); --