New Topic/Question
Reply
is there a way to dump a db, structure and data, if i don't have phpmyadmin?
11 Replies - 2335 Views - Last Post: 06 May 2004 - 09:59 AM
Rate Topic:
MultiQuoteReplies To: Dumping Db Without Phpmyadmin
#2
bazooka tooth
- risky operation, but worth it.
Reputation: 0
- Posts: 1,205
- Joined: 01-October 02
Was This Post Helpful?
0
#4
bazooka tooth
- risky operation, but worth it.
Reputation: 0
- Posts: 1,205
- Joined: 01-October 02
Re: Dumping Db Without Phpmyadmin
Posted 09 November 2002 - 11:25 AM
no problem.. i learned it at the same time as you 
Was This Post Helpful?
0
#5
ranvier
- New D.I.C Head
Reputation: 0
- Posts: 2
- Joined: 04-May 04
Re: Dumping Db Without Phpmyadmin
Posted 04 May 2004 - 01:20 AM
If you use MS SQL then you can use query analyser to do it.
Hmm...it's quite simple actually. I believe you should not have any problem understanding.
If dump means "DROP" then:
1. To "DROP" a table -
DROP TABLE TableName
2. To "DROP" a row -
DELETE FROM TableName
WHERE ColumnName ='SOMETHING'
3. TO "DROP" all data in a table but not "DROP" that table -
DELETE FROM TableName
Hmm...it's quite simple actually. I believe you should not have any problem understanding.
If dump means "DROP" then:
1. To "DROP" a table -
DROP TABLE TableName
2. To "DROP" a row -
DELETE FROM TableName
WHERE ColumnName ='SOMETHING'
3. TO "DROP" all data in a table but not "DROP" that table -
DELETE FROM TableName
Was This Post Helpful?
0
#6
skyhawk133
- Head DIC Head
-
Reputation: 1813
- Posts: 20,232
- Joined: 17-March 01
Re: Dumping Db Without Phpmyadmin
Posted 04 May 2004 - 06:15 AM
Actually, dump is commonly used to 'backup' a database, dropping would, as you said, delete it.
Here is a quick tutorial that DreamStudios has for their clients on how to dump and restore a database using SSH:
http://dream-studios...on.php?qstId=31
Here is a quick tutorial that DreamStudios has for their clients on how to dump and restore a database using SSH:
http://dream-studios...on.php?qstId=31
Was This Post Helpful?
0
#7
skyhawk133
- Head DIC Head
-
Reputation: 1813
- Posts: 20,232
- Joined: 17-March 01
Re: Dumping Db Without Phpmyadmin
Posted 04 May 2004 - 06:15 AM
Welcome to dream.in.code by the way!!!! Great to see new members!
Was This Post Helpful?
0
#8
cyberscribe
- humble.genius
-
Reputation: 10
- Posts: 1,062
- Joined: 05-May 02
Re: Dumping Db Without Phpmyadmin
Posted 04 May 2004 - 03:32 PM
dump != drop
ms sql != mysql
query analyzer != mysql admin
ms sql != mysql
query analyzer != mysql admin
This post has been edited by cyberscribe: 04 May 2004 - 03:35 PM
Was This Post Helpful?
0
#9
skyhawk133
- Head DIC Head
-
Reputation: 1813
- Posts: 20,232
- Joined: 17-March 01
Re: Dumping Db Without Phpmyadmin
Posted 04 May 2004 - 04:10 PM
lol.
That too
That too
Was This Post Helpful?
0
#11
skyhawk133
- Head DIC Head
-
Reputation: 1813
- Posts: 20,232
- Joined: 17-March 01
Re: Dumping Db Without Phpmyadmin
Posted 06 May 2004 - 06:29 AM
No problem, that's the way we learn around here. If you haven't ever done it, there's no way for you to know unless someone tells you
Hope to see you around again.
Hope to see you around again.
Was This Post Helpful?
0
#12
cyberscribe
- humble.genius
-
Reputation: 10
- Posts: 1,062
- Joined: 05-May 02
Re: Dumping Db Without Phpmyadmin
Posted 06 May 2004 - 09:59 AM
ranvier, on May 6 2004, 03:57 AM, said:
Apologies.
None need. Like Skyhawk133 said, welcome aboard.
Was This Post Helpful?
0
Page 1 of 1
|
|
| 