Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Forums
Blogs
Articles
Groups
Galleries
Member List
Calendar
Home
Forum
Simply Business
Fucking Around & Business Discussion
Mysql backup question
Mysql backup question
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
acctman
Confirmed User
Join Date:
Oct 2003
Posts:
2840
Share
Post
#1
Mysql backup question
04-12-2005, 01:52 PM
anyone know how to back up a mysql database via shell?
mrthumbs
salad tossing sig guy
Join Date:
Apr 2002
Posts:
11702
Share
Post
#2
04-12-2005, 01:53 PM
mysqldump -u username -ppassword databasename > database.sql
Comment
Post
Cancel
mrthumbs
salad tossing sig guy
Join Date:
Apr 2002
Posts:
11702
Share
Post
#3
04-12-2005, 01:54 PM
and its -ppassword not -p password like it is with username!
Comment
Post
Cancel
notjoe
Confirmed User
Join Date:
May 2002
Posts:
5599
Share
Post
#4
04-12-2005, 01:56 PM
Originally posted by
mrthumbs
and its -ppassword not -p password like it is with username!
The other option is to run it with replication
Comment
Post
Cancel
Babaganoosh
♥♥♥ Likes Hugs ♥♥♥
Join Date:
Nov 2001
Posts:
15841
Share
Post
#5
04-12-2005, 01:58 PM
You have a BSD image in your sig but you don't know how to back up mysql? Too funny. Poseur.
I like pie.
Comment
Post
Cancel
rickholio
Confirmed User
Join Date:
Jan 2004
Posts:
1914
Share
Post
#6
04-12-2005, 02:06 PM
Originally posted by
Babaganoosh
You have a BSD image in your sig but you don't know how to back up mysql? Too funny. Poseur.
And another
for reference to Takeshi's Castle.
~
Comment
Post
Cancel
fris
Too lazy to set a custom title
Join Date:
Aug 2002
Posts:
55679
Share
Post
#7
04-12-2005, 02:08 PM
when you do -p it prompts you for a pass
Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.
Comment
Post
Cancel
acctman
Confirmed User
Join Date:
Oct 2003
Posts:
2840
Share
Post
#8
04-12-2005, 02:10 PM
many thanks =)
Comment
Post
Cancel
acctman
Confirmed User
Join Date:
Oct 2003
Posts:
2840
Share
Post
#9
04-12-2005, 02:13 PM
Originally posted by
Babaganoosh
You have a BSD image in your sig but you don't know how to back up mysql? Too funny. Poseur.
to many commands to remember. plus i've never done a manual backup usually do it through phpmyadmin but now i know
Comment
Post
Cancel
teksonline
So Fucking Banned
Join Date:
Jan 2005
Posts:
2904
Share
Post
#10
04-12-2005, 02:39 PM
why dont you just download the mysql administrator for your windows machine
Comment
Post
Cancel
Previous
template
Next
Working...
OK
OK
Cancel
😀
😂
🥰
😘
🤢
😎
😞
😡
👍
👎
☕
Comment