11 Replies - 2471 Views - Last Post: 06 May 2004 - 09:59 AM Rate Topic: -----

#1 fyrestorm  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 10
  • View blog
  • Posts: 3,113
  • Joined: 04-April 02

Dumping Db Without Phpmyadmin

Posted 08 November 2002 - 10:48 AM

is there a way to dump a db, structure and data, if i don't have phpmyadmin?
Is This A Good Question/Topic? 0
  • +

Replies To: Dumping Db Without Phpmyadmin

#2 bazooka tooth  Icon User is offline

  • risky operation, but worth it.

Reputation: 0
  • View blog
  • Posts: 1,205
  • Joined: 01-October 02

Re: Dumping Db Without Phpmyadmin

Posted 08 November 2002 - 11:53 AM

RTFM! ;)
dumps like a truck
Was This Post Helpful? 0
  • +
  • -

#3 fyrestorm  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 10
  • View blog
  • Posts: 3,113
  • Joined: 04-April 02

Re: Dumping Db Without Phpmyadmin

Posted 09 November 2002 - 08:01 AM

thanks mudslide, i appreciate it...
Was This Post Helpful? 0
  • +
  • -

#4 bazooka tooth  Icon User is offline

  • risky operation, but worth it.

Reputation: 0
  • View blog
  • 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  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • 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
Was This Post Helpful? 0
  • +
  • -

#6 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1877
  • View blog
  • Posts: 20,284
  • 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
Was This Post Helpful? 0
  • +
  • -

#7 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1877
  • View blog
  • Posts: 20,284
  • 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  Icon User is offline

  • humble.genius
  • member icon

Reputation: 10
  • View blog
  • 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

This post has been edited by cyberscribe: 04 May 2004 - 03:35 PM

Was This Post Helpful? 0
  • +
  • -

#9 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1877
  • View blog
  • Posts: 20,284
  • Joined: 17-March 01

Re: Dumping Db Without Phpmyadmin

Posted 04 May 2004 - 04:10 PM

lol.


That too :)
Was This Post Helpful? 0
  • +
  • -

#10 ranvier  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 04-May 04

Re: Dumping Db Without Phpmyadmin

Posted 06 May 2004 - 03:57 AM

Alright. Apologies.

Thanks for the welcome, skyhawk133
Was This Post Helpful? 0
  • +
  • -

#11 skyhawk133  Icon User is offline

  • Head DIC Head
  • member icon

Reputation: 1877
  • View blog
  • Posts: 20,284
  • 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.
Was This Post Helpful? 0
  • +
  • -

#12 cyberscribe  Icon User is offline

  • humble.genius
  • member icon

Reputation: 10
  • View blog
  • 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