SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
Thread: Trying to dump MySQL schema....
Hybrid View
-
Dec 4, 2008, 08:57 #1
- Join Date
- Mar 2008
- Posts
- 129
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Trying to dump MySQL schema....
Hey all.
I'm trying to get a hold of MySQL and am trying to dump the schema. This is the command I'm using:
mysql> mysqldump -user root -password=rootpass flatland > flatland.dump;
And this is the error I'm getting:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -user root -password=rootpass flatland > flatland.dump' at line 1
Any suggestions? I'm running the latest version of MySQL.
-
Dec 4, 2008, 08:58 #2
- Join Date
- Mar 2008
- Posts
- 129
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Using MySQL on a Mac (Leopard)
-
Dec 4, 2008, 16:45 #3
- Join Date
- Feb 2004
- Location
- Tampa, FL (US)
- Posts
- 9,854
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
mysqldump is a OS command, not a mysql command. run that at an OS command prompt.
Check out our new Industry News forum!
Keep up-to-date with the latest SP news in the Community Crier
I edit the SitePoint Podcast
-
Dec 4, 2008, 17:59 #4
- Join Date
- Mar 2008
- Posts
- 129
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Yeah, I figured that out after much deliberation. I think I'm turning the corner on getting the jist of how MySQL works.
-
Dec 6, 2008, 10:17 #5
Bookmarks