We hope you enjoy your visit.

You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free.


Join our community!


If you're already a member please log in to your account to access all of our features:

Username:   Password:
Add Reply
MySQL Dump; Not on the command Line
Topic Started: Mar 23 2005, 01:14 PM (465 Views)
Dennis Mar 23 2005, 01:14 PM Post #1
Member
[ * * * * * * * ]
 How do I perform a dump that will backup the information in a database without deleting the information? I know how to do it via the command line, but is there a way to do it with a query?
Offline Profile Quote Post Goto Top
 
Seth Mar 23 2005, 02:56 PM Post #2
Member Avatar
I has a pony
[ * * * * * * * * * ]
 You can't do it easily. Just use a command line, SSH is your friend. If your database is very big at all you can't even do it via web; things will time out.
Offline Profile Quote Post Goto Top
 
Dennis Mar 23 2005, 08:46 PM Post #3
Member
[ * * * * * * * ]
 Well, is there a way that I can set it up to click a button and dump? Like inside a program.
Offline Profile Quote Post Goto Top
 
Seth Mar 23 2005, 11:13 PM Post #4
Member Avatar
I has a pony
[ * * * * * * * * * ]
 Query Browser
Offline Profile Quote Post Goto Top
 
nickoladze Mar 24 2005, 11:01 AM Post #5
Member
[ * ]
 phpmyadmin :D
Offline Profile Quote Post Goto Top
 
MegaKN Mar 24 2005, 11:17 AM Post #6
Ketchup is for winners, Ted.
[ * * * * * ]
nickoladze
March 24, 2005 10:01 AM
phpmyadmin :D

Yes, in phpMyAdmin, you can go to Export, pick what you want to export, and easily do it. ^_^
Offline Profile Quote Post Goto Top
 
Seth Mar 24 2005, 12:12 PM Post #7
Member Avatar
I has a pony
[ * * * * * * * * * ]
nickoladze
March 24, 2005 09:01 AM
phpmyadmin :D

I think he wanted a client-side program, wasn't sure though. If not, phpMyAdmin is great.
Offline Profile Quote Post Goto Top
 
Dennis Mar 27 2005, 09:27 PM Post #8
Member
[ * * * * * * * ]
 I use PHPMyAdmin for my purposes, but I want it available to the client as a feature. Thanks All.
Offline Profile Quote Post Goto Top
 
Dennis Mar 28 2005, 02:51 PM Post #9
Member
[ * * * * * * * ]
 Seth... I downloaded that program, and it's nice, but I can't figure out how to do a dump. Anyone know the actual query?
Offline Profile Quote Post Goto Top
 
Seth Mar 28 2005, 03:16 PM Post #10
Member Avatar
I has a pony
[ * * * * * * * * * ]
 SELECT * FROM field1, field2, field3, ... fieldn

File > Export Resultset
Offline Profile Quote Post Goto Top
 
0 users reading this topic
« Previous Topic · Technology Chat · Next Topic »
Add Reply