Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. abombss

    Can't connect to local MySQL server through socket '/tmp/mysql.sock'

    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
  2. abombss

    Can't connect to local MySQL server through socket '/tmp/mysql.sock'

    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
  3. abombss

    Live backup of a "static" database

    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...
  4. abombss

    VB.NET + MyODBC: Option Values??

    Have you tried the native .NET driver? http://sourceforge.net/projects/mysqlnet/ abombss
  5. abombss

    DISTINCT Problem

    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
  6. abombss

    DISTINCT Problem

    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...
  7. abombss

    Best DB and language for scheduling app

    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...
  8. abombss

    Fulltext query extremely slow

    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
  9. abombss

    How to FTP a MySQL database

    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...
  10. abombss

    Learning MYSQL, following steps from a book and have run into an error

    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
  11. abombss

    Learning MYSQL, following steps from a book and have run into an error

    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...
  12. abombss

    Mysql Select Problem

    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
  13. abombss

    Transfer MySQL data from Windows to Linux

    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...
  14. abombss

    Multiple Column Indexing

    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
  15. abombss

    workaround for not being able to use an alias in the Where clause of m

    Check out this thread, it looks like it might help. thread436-601190 abombss
  16. abombss

    Re-ordering values in table

    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...
  17. abombss

    how can i use the mysql database in visual basic

    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
  18. abombss

    Free Database - does such a thing exist?

    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
  19. abombss

    libmysqlclient.lib / libmysqlclient.a

    I think you will need to try building the the libraries from source. Check out this link. http://www.mysql.com/doc/en/configure_options.html abombss
  20. abombss

    Syntax error while logging to mysql db

    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...

Part and Inventory Search

Back
Top