Mr. Jerry/and all,
I am drooping this idea of making schema encryption . As it leads to lots of
confusion as Mr. John said.
I am following the data level encription.
Thank you for the comments.
Vikram
From: Jerry Schwartz
To: 'Vikram A' ; 'Johan De Meersman'
I think I may have corrupt data. In one of my shopping cart installs,
no orders were getting written to the orders table. Other tables, like the
customers table, were being written to just fine.
In phpMySQL, I ran check, optimize, repair, and analyze on the orders
table, and t
I copied /var/lib/mysql and I am ready to transplant it. But when I
copied, permissions and ownership for files and dirs was not retained.
You said to be careful about permissions, could you elaborate on that a
bit more. On the original hard disk I copied from I did ls -l on some
dirs for example:
Lee,
do this:
sudo chown -R mysql:mysql /media/fd453d5c-81f5-9c66ff4685bc/lib/mysql
in your /etc/my.cnf check that:
datadir=/media/fd453d5c-81f5-9c66ff4685bc/lib/mysql
and you should be able to start it
also set the mysql error log to a known position:
log-error=/var/log/mysql_123.log (o
Is there an optimal 'alignment' for column widths for
varchar types?
I.E., divisible by 8 or 10 or by powers of 2?
URLs to documentation would be more than sufficient.
Version 5+, linux platforms.
thanks
--
Tim
tim at johnsons-web dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MyS
In the last episode (Jun 18), Tim Johnson said:
> Is there an optimal 'alignment' for column widths for
> varchar types?
>
> I.E., divisible by 8 or 10 or by powers of 2?
No. Varchar fields are stored using only as many bytes as are in that
particular entry. The size in the column definition is