MySQL Forums
Forum List  »  Backup

reloading backup
Posted by: Grant Cahill
Date: July 12, 2005 10:46AM

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.


Options: ReplyQuote

Written By
reloading backup
July 12, 2005 10:46AM
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.