I would like to know the correct way to move the mysql data directory to
a different disk partition, so that the data can be accessed by mysql
under linux or windows. I'm using Ubuntu 7.1 and Windows XP.
I copied the data directory to a separate partition.
I then changed the datadir in my.cnf,
Ryan Stille wrote:
boll wrote:
Hello-
I'm working with an unfamiliar application, trying to figure out
where my data is going.
Is it possible to form a query to select from all the columns in
several tables at once? Something equivalent to:
SELECT FROM * WHERE * = 'john
Hello-
I'm working with an unfamiliar application, trying to figure out where
my data is going.
Is it possible to form a query to select from all the columns in several
tables at once? Something equivalent to:
SELECT FROM * WHERE * = 'john smith';
If that's not possible I'd still like to
27;widgets';
should do what you want.
Regards,
Jocelyn Fournier
www.mesdiscussions.net
boll a écrit :
This query will display from the 'products' and 'qty_price' tables
when the 'products.sku' and 'qty_price.qsku' fields match:
SELECT prod
This query will display from the 'products' and 'qty_price' tables when
the 'products.sku' and 'qty_price.qsku' fields match:
SELECT products.sku, products.title, products.price,
qty_price.qty, qty_price.qprice
FROM products, qty_price WHERE products.sku = qty_price.qsku
AND products.vendor_id=1
boll wrote:
Dominik Klein wrote:
Did you check FAT-permissions?
When mounting a FAT-partition, you have to set explicit permissions
while mounting as FAT does not understand the unix permission concept.
Try to mount this way:
mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007
/dev
Dominik Klein wrote:
Did you check FAT-permissions?
When mounting a FAT-partition, you have to set explicit permissions
while mounting as FAT does not understand the unix permission concept.
Try to mount this way:
mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007
/dev/[yourdevicename] /your
Hi-
Using MySQL 4.1.11 on Fedora 4.
I moved my data directory to a FAT partition in order to share it with
Windows dual-boot.
Now when I try to start mysqld normally, it fails with these messages in
the log:
060420 18:16:03 mysqld started
060420 18:16:03 [Warning] Can't create test file
/mnt