Re: INSERT encrypted data
On 1/19/06, Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. What doesn't work? In case you want more help please, provide the results you want obtain from your query and CREATE statement for you table. Sorry for not being clear. The data is getting saved as 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 - ; +--+-+ | crypt| expire | +--+-+ | )\u\u\u\u\u\u\u | 10/2003 | | )\u\u\u\u\u\u\u | 10/2003 | | )\u\u\u\u\u\u\u | 10/2003 | | )\u\u\u\u\u\u\u | 10/2003 | +--+-+ 4 rows in set (0.00 sec) why doesn't this work? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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/2003 | | )\u\u\u\u\u\u\u | 10/2003 | | )\u\u\u\u\u\u\u | 10/2003 | | )\u\u\u\u\u\u\u | 10/2003 | +--+-+ 4 rows in set (0.00 sec) why doesn't this work? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Backup/Dump
I just moved my databases to 4.1 from 3.23. It went pretty smoothly. First I used mysqldump to back up the data. Then installed 4.1. First thing did was import only the mysql table. Then ran /mysql_fix_privilege_tables command. After that I was able to login to mysql with my old root password. On 6/15/05, Kishore Jalleda [EMAIL PROTECTED] wrote: It is recommended that you upgrade to 4.0.x first from 3.23.xx, because of any changes to the grant tables in the mysql database, make sure you read the upgrade notes before upggrading, here's a good link to upgrade, http://dev.mysql.com/doc/mysql/en/upgrade.html I find it very simple to zip all the databases to be dumped from the old server, and unzip them into the new box instead of a mysqlimport etc and hopefully it should work, # zip -r backup.zip database1 database2 ... . the go to data dir and #unzip backup.zip Kishore On 6/14/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: different box, different versions, use export/import (backup table or LOAD DATA) Mathias Selon Kory Wheatley [EMAIL PROTECTED]: I want to backup our entire Mysql database structure for mysql 3.23.58 and dump it in the newly installed mysql 4.1.10 What is the best command to do a backup and dump everything into the new MYSQL version on a different box? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Sharif Islamhttp://www.sharifislam.com Research Programmer University of Illinois, Urbana-Champaign Library Systems Office217-244-4688 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Feb 25 14:22 .. drwxrwx--x 2 mysql mysql 4096 Feb 25 14:22 mysql drwxrwxr-x 2 mysql mysql 4096 Feb 25 14:22 test -rw-rw 1 mysql mysql 1953 Mar 18 11:01 mymachine.err There's no mymachine.pid. The permission on /var/lib/mysql seems to be right. I am using Fedora core 3. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.com/[EMAIL PROTECTED]
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); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]