Store Backed Up - Reprovisioned Server... Now What?

[sledp0rn]

Hi all, I recently had to reprovision my server to "upgrade" according to GoDaddy.

 

So I backed up my database in phpmyadmin and also backed up via ftp the entire oscommerce directory.

 

Now I have put back the osCommerce directory via ftp (except osCommerce/index.php until I get the database up and going).

 

I tried making a database called "store" in my plesk control panel, then I wanted to restore my old "store" database via phpadmin, but this does not seem to be an option as I cannot "browse" for the backup under the SQL tab of the database? Is it because I do not have the table structure in the database?

 

How do I go about gettig this thing back up and running again?

[♥geoffreywalton]

In phpmyadmin click on an sql tab to give you a widow in which you can paste the entire contents of your sql backup.

 

It should contain lines like

 

DROP TABLE IF EXISTS newsdesk_categories_description;

CREATE TABLE newsdesk_categories_description (

categories_id int(11) NOT NULL default '0',

language_id int(11) NOT NULL default '1',

categories_name varchar(32) NOT NULL default '',

PRIMARY KEY (categories_id,language_id),

KEY idx_categories_name (categories_name)

) TYPE=MyISAM;

 

--

-- Dumping data for table `newsdesk_categories_description`

--

 

INSERT INTO newsdesk_categories_description (categories_id, language_id, categories_name) VALUES (1, 1, 'image'),

(1, 2, 'Bild'),

(1, 3, 'imagen'),

(1, 4, 'image'),

(1, 5, 'beeld'),

(2, 1, 'one image'),

(2, 2, 'ein Bild'),

(2, 3, 'una imagen'),

(2, 4, 'une image'),

(2, 5, 'één beeld'),

(3, 1, 'off'),

(3, 2, 'weg von'),

(3, 3, 'de'),

(3, 4, 'outre de'),

(3, 5, 'van'),

(4, 1, 'sticky'),

(4, 2, 'klebrig'),

(4, 3, 'pegajoso'),

(4, 4, 'collant'),

(4, 5, 'kleverig'),

(5, 1, 'nested top'),

(5, 2, 'genistete Oberseite'),

(5, 3, 'tapa jerarquizada'),

(5, 4, 'dessus niché'),

(5, 5, 'genestelde bovenkant'),

(6, 1, 'nested down one'),

(6, 2, 'genistet hinunter ein'),

(6, 3, 'jerarquizado abajo de uno'),

(6, 4, 'niché en bas d''un'),

(6, 5, 'genesteld onderaan'),

(7, 1, 'nested down two'),

(7, 2, 'genistet hinunter zwei'),

(7, 3, 'jerarquizado abajo de dos'),

(7, 4, 'niché en bas de deux'),

(7, 5, 'genesteld onderaan twee'),

(8, 1, 'nested down three'),

(8, 2, 'genistet hinunter drei'),

(8, 3, 'jerarquizado abajo de tres'),

(8, 4, 'niché en bas de trois'),

(8, 5, 'genesteld onderaan drie'),

(9, 1, 'no image'),

(9, 2, 'kein Bild'),

(9, 3, 'ninguna imagen'),

(9, 4, 'aucune image'),

(9, 5, 'geen beeld');

[sledp0rn]

Thank you! That was what I needed to do!