It sounds like a permissions thing. For the import, try adding a few more permissions to that user. You can do this through phpmyadmin under privileges. Otherwise try doing it as root.
It may also have something to do with file permissions on sql.txt. Try placing the file in / and change...
A Newbie? Welcome to the wonderful world of MySQL. There are several ways of importing text into MySQL. The LOAD DATE INFILE mentioned above is a great way to do it. However, if you're new, you are may be wondering how to give SQL commands to the database. There's a couple of ways. First...
I've never seen this done. Were you going to try to link an Access table?
The function of linking external data is usually done in the programming language. Microsoft Access has Visual Basic built into it, however mysql is not a programming language by most standards. If you want to use...
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.