The easiest way is simply to copy the files. Go to the directory that mysql
was installed to. There should be a subdirectory called data. Under that
should be a subdirectory named after your database. You can simply copy that
entire subdirectory to a mysql server and the database will be copied
Hello,
I am trying to understand a fundamental concept here. Lets say we have two
tables:
CREATE TABLE codewords (id INT UNSIGNED not null AUTO_INCREMENT, word
VARCHAR (60) not null , fkey_humanword INT UNSIGNED not null , PRIMARY KEY
(id), INDEX (id), UNIQUE (id))
CREATE TABLE humanword (id
I am having a problem determining the best SQL DB schema to use. I have a
table
which stores attributes on homes, attributes such as square footage,
price, or includes pool. Now the problem I am having is how to store the
actual value of the attributes. An attribute like square footage or
price
Sam, I am constantly coding with PHP and MySQL. As far as:
Would you agree that sorting small row sets on the client with say PHP
is more efficient than asking a busy MySQL server with many clients to
o ORDER BY so that FILESORT or TEMPORARY can be avoided ?
I have learned to let MySQL do