Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mysqldump problem with $?

Status
Not open for further replies.
bonosa

bonosa

Programmer
May 19, 2004
76
US
On windows I can mysqldump easily a table named pru$1$10. But on linux I get the error:

1146: Table 'pmadb1.pru0' doesn't exist when doing LOCK TABLES where it looks like the dollar sign is causing a problem. Is this a known issue?

Thanks,
sb

 
Sort by date Sort by votes
The dollar signs are probably being interpretted by your shell. Put the table name in single quotes on the command line.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
326
Chris Miller
Chris Miller
BJZeak
  • Locked
  • Question
need help with .sql insert statement
Replies
1
Views
109
spamjim
spamjim
eizs002
  • Locked
  • Question
Connect MS Access to mysqlDB without ODBC
Replies
3
Views
265
spamjim
spamjim
Nigel Gomm
  • Locked
  • Question
MariaDB ODBC connector 3.1.4 with BEGIN ATOMIC
Replies
1
Views
83
Nigel Gomm
Nigel Gomm
AM_WG
  • Locked
  • Question
I need some help with SQL
Replies
13
Views
212
AM_WG
AM_WG

Part and Inventory Search

Sponsor

Back
Top