I am sorry... I forget to set the sticky bit. Try this command instead.
chmod -R 1777 /tmp
This will allow anyone to read / write / execute a file in the temp directory. A more conservative setting would be.
chmod -R 1755 /tmp
Cheers,
abombss
It sounds like the permissions on your temp directory are incorrect. You need to set the sticky bit. Try running this command.
chmod -R 777 /tmp
abombss
If the database is readonly you shouldn't have a problem. But I would highly recommend running the MySQL Hotcopy perl script if you can. It will safely lock the database for you and copy the proper definition, data and index files if you need it.
I have copied, tar'd a live readonly database...
Sorry... I submitted the previous post on accident. Here is the correct syntax for the first query I posted.
SELECT DISTINCT ProductID
FROM Products
WHERE ProductDate >= #1/1/03# AND ProductDate <= #6/1/03#
ORDER BY ProductDate;
Good Luck,
abombss
Well read up on SQL http://www.w3schools.com/sql/default.asp The DISTINCT clause only eliminates duplicate rows from the result, not duplicate columns. If you want unique product id's order by date, but don't need the date try this.
SELECT DISTINCT ProductID, ProductDate
FROM Products...
If the schools are networked well it might be easier to do a PHP / MySQL thing, however the teachers would need access to the system to update data.
With Access, you could have a fron end and back end. The teachers can keep copies of the front end, update data etc. Then sync with the back end...
Are the queries using wild cards in the front, ex. like '%KeyWord%'. If so, the indexes are probably not being used and every query is running a full table scan. Post some queries, plan statements, and benchmarks and we can help.
abombss
You can use ftp to transfer database files and do backups. This is probably one of my favorite features of the database. Regardless of the platform you are on the files will transfer and work from one server to the next, assuming there are no file size limitations.
Just make sure the mysql...
The % is used as wild card chacter for a fuzzy match just as its used in the LIKE statement. This means that root can connect from any host.
If your domain was foobar.com and you only wanted connections from that domain you could say %foobar.com.
abombss
Try logging into the server, either with a password or without. Then type the following commands
\u mysql
select user, host, password from user;
If your root user is setup properly you will see something like. The below example allows my root user to log in from only to hosts, the local...
It looks like this was a bug that has been fixed. You may need to patch your server or use the workarounds. Here is the link to the bug.
http://bugs.mysql.com/bug.php?id=614
abombss
Just make sure the server is not running or all the tables are locked when copying or they might end up corrupt. If bandwidth is an issue you do not need move index files, you can rebuild those later.
Check the mysqlhostcopy.pl script, its a great tool for this kind of stuff, it even has some...
It also depends on the cardinality of the data. I would only index the most frequently used columns that are the most unique. Adding an index to column with few distinct values does not help.
I would log some queries for a couple days, analyze them, then build your indexes.
abombss
Couldn't have said it better myself sleipnir214.
But I would assume if you insert the keys in order they will come back in order, or if you have an index on the keys and the query uses the index they may come back in that in order.
So while this is not guranteed to work, should not be relied...
The easiest is to use MyODBC and ADO. If your familiar with VB just download the ODBC driver from mysql.com and get to work.
Otherwise read up on ADO and ODBC is pretty straight forward once you get started.
abombss
Berkely DB is another C database layer that is very good and very popular. They have support MS Visual C++ but it might be difficult to build a wrapper to the API in VB.
http://www.sleepycat.com/
Might be a cool project.
abombss
I have never gotten the MyODBC driver to work for situations like you describe. I tried running DTS packages on our SQL Server to a MySQL server and they always failed while trying to insert data. I don't think the ODBC is very stable, it works for some stuff but not everything.
In light of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.