Search code examples
mysqlsystemcd

mysql system command

I am in MySQL and would like to change the current working directory. I tried to execute:

mysql> system cd './my_dir'

However, this does not seem to work. Has anyone run into a similar problem?

Solution

  • System is going to spawn a child process to run a shell command.....

    Current working directory is a process level property....so you can't change it in the parent from a child process. That's why it doesn't work.

    I briefly scanned the MySQL docs at http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html but didn't see a direct CD command that changes the working directory. I think an adventurous person could write one....