Which backup should I use for back/restore?

[Guest]

I saw two backups for OSC, one from PHPMYADMIN where I drop the entire databse, and the other one is from Database Backup Manager from OSC Admin/Tools, it appears that they are different, so which one should I for the backup/restore purpose？

 

Thanks

[AlanR]

I saw two backups for OSC, one from PHPMYADMIN where I drop the entire databse, and the other one is from Database Backup Manager from OSC Admin/Tools, it appears that they are different, so which one should I for the backup/restore purpose？

 

Thanks

They are the same providing you made them at the same time. You may not be choosing the DROP TABLE IF EXISTS and CREATE TABLE IF NOT EXISTS options in PMA. osC does this for you.

 

One difference is that you can configure the phpMyAdmin dump while the osC one is preconfigured for you. That's probably why they look different.

 

You may find one problem if you choose to Export from PMA's startup window. It will add a CREATE DATABASE command which may choke you because you probably don't want to and may not have the authority to create databases. You'll get "a denied". You can delete that line in a text editor or choose to export from a different window and avoid that problem.

 

This is the header from a "main page" dump.

 

-- phpMyAdmin SQL Dump

-- version 2.8.0-rc1

-- http://www.phpmyadmin.net

--

-- Host: xxxxxxxx.net

-- Generation Time: Feb 21, 2006 at 07:12 PM

-- Server version: 4.0.25

-- PHP Version: 5.1.2

--

-- Database: `xxxxxxxxxx`

--

CREATE DATABASE `xxxxxxxxx`; <-- causes problems on shared servers

USE xxxxxxxxxx; <-- causes problems on shared servers

[Guest]

I probably just use osC's then for backup and restore.

Thanks