Backups.

Forum Moderators: open

Message Too Old, No Replies

Backups.

When webhosts are less than helpful...

Gibble

2:25 pm on Jul 24, 2006 (gmt 0)

So, unfortunately, we have a SQL Server 2000 database on a hosting plan, the only access to it is through a stripped down version of myLittleAdmin...with the backup option absent. The Webhosts CP has nothing for backing up the SQL Server database.

Is there a php or asp, or sql script around that will allow me to backup my tables, data, procs, and views?

I'd like to be able to get a copy of this db on my laptop for development purposes.

...I really hate this webhost...

Thanks,
Gibbs.

physics

2:46 am on Jul 25, 2006 (gmt 0)

You might be able to use phpMyAdmin for this:
[phpmyadmin.net...]

FalseDawn

3:55 am on Jul 25, 2006 (gmt 0)

phpMyAdmin is for MySQL, not SQL server 2000.

A little more info would help. Do you have root access? shared or dedicated?
Really, a hosting account that doesn't provide you with the means to backup a database either through the CP or the command line is not good. There's no reason why backing up a database should be disabled in MyLittleAdmin - I'd ask your host to enable it.
If you can open an interactive SQL prompt, the BACKUP DATABASE command can probably be used as well.

Gibble

2:33 pm on Jul 25, 2006 (gmt 0)

I eventually recreated all the tables, procs, and views by hand...then found a script called sp_generate_inserts (google for it) to get the data.

[edited by: Gibble at 2:33 pm (utc) on July 25, 2006]

Backups.

When webhosts are less than helpful...

Gibble

physics

FalseDawn

Gibble

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week