Welcome Guest!

If you do not have an account yet on The Web Squeeze forums, please Register! It’s FREE and there are many benefits:

  • Receive Fast Advice
  • Learn Programming Languages
  • Get Professional Website Reviews
  • Quick Troubleshooting Assistance

> Downloading/taking A Dump Of A Database

This is a discussion on Downloading/taking A Dump Of A Database, within the MySQL section. This forum and the thread "Downloading/taking A Dump Of A Database" are both part of the Programming Your Website category.

 
 Reply to this topicStart new topic
> Downloading/taking A Dump Of A Database
edd
post Apr 15 2008, 09:00 AM
Post #1


Fresh Squeezed
**

Posts: 15
Joined: 18-March 08
I need to switch servers, and my current one has a mysql database on it. The problem is, my current host doesn't have php myadmin. How can I download my database so that I can move it? Any help would be great.
Go to the top of the page
 
+Quote Post
c010depunkk
post Apr 15 2008, 10:42 AM
Post #2


Rapid Squeezer
Group Icon

Posts: 197
Joined: 14-February 08
From: Willich, Germany
You could use PHP:
http://www.php-mysql-tutorial.com/perform-...-backup-php.php
http://www.fluffycat.com/SQL/MySQL-Database-Backup-With-PHP/
http://www.phpmybackuppro.net/
http://directory.fsf.org/project/PHPBackupMaker/
http://www.0php.com/MySQL-Backup.php


--------------------
www.c010depunkk.com ~ the hangout of a web developer
Go to the top of the page
 
+Quote Post
paintingtheweb
post Apr 17 2008, 01:22 PM
Post #3


Squeezing
***

Posts: 76
Joined: 14-February 08
From: Las Vegas, NV
QUOTE (edd @ Apr 15 2008, 06:00 AM) *
I need to switch servers, and my current one has a mysql database on it. The problem is, my current host doesn't have php myadmin. How can I download my database so that I can move it? Any help would be great.

You can also download the trial of SQLYog (http://www.sqlyog.com - my favorite DB tool). It'll take your database and convert it to an SQL Dump, save it on your machine, then connect to your new database and import the dump. It'll probably take a while depending on how big your database is, but it works nicely.

This post has been edited by paintingtheweb: Apr 17 2008, 01:24 PM


--------------------
http://www.infoonmike.com

"Always program as if the person who will be maintaining your program is a violent psychopath that knows where you live." Martin Golding
Go to the top of the page
 
+Quote Post
Mark
post Apr 17 2008, 02:19 PM
Post #4


Don deluzione
Group Icon

Posts: 1,174
Joined: 13-February 08
From: Canada eh?
QUOTE (edd @ Apr 15 2008, 08:00 AM) *
I need to switch servers, and my current one has a mysql database on it. The problem is, my current host doesn't have php myadmin. How can I download my database so that I can move it? Any help would be great.

Ask your host to make the backup.. It's yours, so you have the right to download it. If they don't give you a way to download it, it's their problem..


--------------------
My Portfolio, Blog, Project and Twitter.
Go to the top of the page
 
+Quote Post
« Next Oldest · MySQL · Next Newest »
 
If you found The Web Squeeze to be helpful, please donate so we can keep this site FREE, FRESH, and fortified with Web Design & Development info!
 Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Collapse

> Similar Topics

    Topic Title Replies Topic Starter Views Last Action
No New Posts   6 Vanessa 282 11th March 2008 - 02:58 PM
Last post by: Vanessa
No New Posts   3 JustinStudios 253 17th March 2008 - 03:29 PM
Last post by: velo
No New Posts   3 acrikey 210 25th April 2008 - 01:17 AM
Last post by: c010depunkk