reloading backup
Hi,
I know this may be a dumb question, but I'm currently going through some problems regarding a reload of a dump.sql file. I'm currently building a user interface with java that allows users to do various things with the database (such as display/modify users, perform backups, reload backups, and so on). Because Java is a little tricky with executing command line prompts, I wanted to reload the file from inside mysql. Anyway, I'm currently testing the code on a windows OS (and will eventually migrate to a Unix based OS) and I'm trying to run the query as follows:
source path/to/file/dump.sql
But there appears to be some problems with mysql finding the file through the pathname. For example, if I place the file in the same directory where I'm executing mysql (meaning I don't have to place a pathname in there, just the filename itself), then it runs fine. However, when I place the file in another directory (forcing me to put the absolute pathname in there), then it pukes on me with error number 1064. Any help with the correct syntax for pathnames in mysql would be great.
Thanks,
Grant
Subject
Views
Written By
Posted
reloading backup
3297
July 12, 2005 10:46AM
2239
July 19, 2005 01:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.