PHP, MySQL restore spaces in dir/file names

[brendon2020]

When restoring tables/db's thru mysql/mysql.exe what is the correct way to restore the table/db when the sql/backup file has spaces in the filename and/or spaces in the directory name? So,

/usr/bin/mysql --user="user" --pass="pass" < "/home/user/some folder/some backup file.sql"

-bash: /home/user/some folder/some backup file.sql: No such file or directory

BTW this is actually for a windows 2k server and i'm working on a ubuntu box, so i'd like is if i can make sure that the dir and filename will work with mysql.exe. TIA

 

[FlipperBizkut]

Try using "%20" (no quotes) instead of spaces. I don't know that it will work, but it might.

good%20luck

 

[brendon2020]

i just installed some mysql binaries on my workstation (xp) and so far it works fine on windows (dir and filenames with spaces). I'll worry about it later for linux.

 

[Lews_Therin]

That is the correct way. Are you sure the file exists at the path you are passing?

 

[brendon2020]

i posted this on serveral forums and geoff2k from EXTREME Overclocking Forums gave this solution which works perfectly on windows and linux
linux:

cat "/home/user/some folder/some backup file.sql" | /usr/bin/mysql --user="user" --pass="pass"

Windows:

type "/home/user/some folder/some backup file.sql" | mysql.exe --user="user" --pass="pass"