I am clueless, please help.

[runforcover]

I have an OScommerce store and 1and1 is my host.

 

I accidentally deleted the database for my store. I called my host and they put a folder in my ftp called dbrestore. There is a file in it with the name of the database (just a bunch of numbers) and ends in .dump.

 

Could anyone guide me on how to get my database back up? I have been losing a lot of sales over the past few days and it's really bugging me.

 

Thank you.

[♥geoffreywalton]

Download the file to your pc and open it using a text editor.

 

If it contains lines like this it is a file that can be imported to mysql. Or it might need unzipping (or you could ask 1&! what to do, or read their help )

 

# osCommerce, Open Source E-Commerce Solutions
# http://www.oscommerce.com
#
# Database Backup For xxxx
# Copyright (c) 2009 xxx
#
# Database: my_db
# Database Server: aaa.bb.com
#
# Backup Date: 01/03/2009 07:47:57

drop table if exists address_book;
create table address_book (
 address_book_id int(11) not null auto_increment,
 customers_id int(11) default '0' not null ,
 entry_gender varchar(4) not null ,
 entry_company varchar(32) ,
 entry_firstname varchar(32) not null ,
 entry_lastname varchar(32) not null ,
 entry_street_address varchar(64) not null ,
 entry_suburb varchar(32) ,
 entry_postcode varchar(10) not null ,
 entry_city varchar(32) not null ,
 entry_state varchar(32) ,
 entry_country_id int(11) default '0' not null ,
 entry_zone_id int(11) default '0' not null ,
 PRIMARY KEY (address_book_id),
 KEY idx_address_book_customers_id (customers_id)
);

[runforcover]

Here's what the first 20 or so lines are.

 

SET FOREIGN_KEY_CHECKS=0;

SET UNIQUE_CHECKS=0;

SET SQL_AUTO_IS_NULL=0;

-- MySQL dump 9.11

--

-- Host: localhost Database: db135462663

-- ------------------------------------------------------

-- Server version 4.0.27-standard-log

 

--

-- Table structure for table `address_book`

--

 

DROP TABLE IF EXISTS `address_book`;

CREATE TABLE `address_book` (

`address_book_id` int(11) NOT NULL auto_increment,

`customers_id` int(11) NOT NULL default '0',

`entry_gender` char(1) NOT NULL default '',

`entry_company` varchar(32) default NULL,

`entry_firstname` varchar(32) NOT NULL default '',

`entry_lastname` varchar(32) NOT NULL default '',

`entry_street_address` varchar(64) NOT NULL default '',

`entry_suburb` varchar(32) default NULL,

`entry_postcode` varchar(10) NOT NULL default '',

`entry_city` varchar(32) NOT NULL default '',

`entry_state` varchar(32) default NULL,

`entry_country_id` int(11) NOT NULL default '0',

`entry_zone_id` int(11) NOT NULL default '0',

PRIMARY KEY (`address_book_id`),

KEY `idx_address_book_customers_id` (`customers_id`)

) TYPE=MyISAM;

 

 

 

 

So I am assuming that's what you mean. How exactly do I import it into My SQL is my question. Is this something 1and1 will guide me through if I call them?

 

Thank you!

[♥geoffreywalton]

Probably

 

Or try google, I tried

 

import sql after disaster

 

but you probably want to find the way to do it using phpmyadmin rather than command line.

[runforcover]

Probably

 

Or try google, I tried

 

import sql after disaster

 

but you probably want to find the way to do it using phpmyadmin rather than command line.

 

 

Thanks Geoff, I will try this.