The Database Forum

**ngsp23** · 12:33 PM

Hi Guys

Hv an existing site and i wonder how to backup the database from my server.

Currently am using this FTP software called CORE and its only allowing me to copy the php scripts tht is running the site.

I need the database installed on my local host so tht i can do some editing which my designer is not very helpful. I do know how to log-in to cpanel and access the mysql.

Thanks in advanced for any help offered.

Rgs

**pushedtomb** · 02-04-2006, 07:46 PM

are you using phpmyadmin?

**ngsp23** · 02-05-2006, 09:02 PM

Yes sir i do.

Its within the cpanel rite?

**Apolo** · 02-16-2006, 10:53 PM

Hi,

If you go to phpMyAdmin, it's quite easy.

To the left, you select your data base name. Then click on "Export" (top).

Then click on "Select all". Then you check the verification box "Sent" and then click on "Continue".

In case you can't do it, just ask your hosting provider for assistance.

Regards,

**Brufton** · 03-13-2006, 11:58 AM

Quote:

Originally Posted by Apolo

If you go to phpMyAdmin, it's quite easy.

To the left, you select your data base name. Then click on "Export" (top).

Then click on "Select all". Then you check the verification box "Sent" and then click on "Continue".

I've tried doing this on my account, but most of the time it just throws a "Page cannot be displayed message". Is this a problem on my server or what?

**metho** · 03-13-2006, 12:42 PM

What does it do the rest of the time? If you're getting 404 erros, then ya, its probably a helpticket issue with your webhost.

**Apolo** · 03-13-2006, 12:43 PM

Quote:

Originally Posted by Brufton

I've tried doing this on my account, but most of the time it just throws a "Page cannot be displayed message". Is this a problem on my server or what?

Seems to be...

Did you contact your current hosting provider about this?

Regards,

**Anacrusis** · 03-13-2006, 12:58 PM

In cPanel you should have a 'Backup' icon where you can backup your full site, just the files or just the database. Take a look in there if phpMyAdmin isn't working for you.

**lack0Fdesign** · 03-28-2006, 03:43 PM

I currently run Apache2Triad 1.5.3: phpMyAdmin 2.6.3-pl1 / MySQL 4.1.14 / PHP 5.0.4 / Apache 2.0.54

But for some reason import is missing from phpMyAdmin, are there any other ways to import *.sql dbs?

**Apolo** · 03-28-2006, 04:33 PM

Quote:

Originally Posted by lack0Fdesign

But for some reason import is missing from phpMyAdmin, are there any other ways to import *.sql dbs?

You can always import them from the command line, or use mysqlimport or use a PHP script to populate your data base, etc.

I recommend you to read MySQL documentation.

Regards,

Jaime