*new to mysql shell* Where is the default dump file location?

[drjman]

For the life of me i can't find where to put a mysql dump file in order to be imported.

\! source dump.sql

If that is the command that i am trying to execute, where should i put the dump.sql file?

thanks for the help

(this is in a new Ubuntu server)

 

[Brazen]

hmm, I do all my mysql admin through phpmyadmin (I would be lost without it), but my guess would be it needs to be in the current directory that you are executing the mysql shell from.

Alternatively, maybe you can specify the full path to the dump file, such as "\! source /path/to/dump.sql"

 

[drjman]

phpmyadmin has upload execute limits on my server and i imagine its easier to find this file location than it is to change those. I agree phpmyadmin is a dream, but not for this situation.

i did try to specify the full path and it did not work. I have moved the dump files around to try different areas, but still no luck.

 

[Brazen]

The upload limits are set in the php.ini file. There are two options you need to change (one is for the size of individual files and the other is for total size of all files when multiple files are uploaded at once). I don't remember the option names off the top of my head, but I could find them if you wanted to explore that route.