I think this is my issue, with all my backups of my old database (dumped from phpmyadmin) with above settings (save as file was checked sorry) this line exists "create database"
Code:
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Host: MySQL.XXXX.com
-- Generation Time: Dec 07, 2007 at 09:34 AM
-- Server version: 4.0.27
-- PHP Version: 4.4.4
--
-- Database: `XXXXX-db101`
--
CREATE DATABASE `XXXXX-db101`;
USE XXXXX-db101;
-- --------------------------------------------------------
--
-- Table structure for table `address_book`
etc..
My new database db102 is empty, but when I try to import from my local file I get an error that that database exists already (db101).
I must import from my saved file, as the server db101 is possibly messed up.
A further mystery is why when I back up my database now, with the same settings the CREATE DATABASE `XXXXX-db101`;
USE XXXXX-db101; is gone.
I have in addition to the .sql file a text file which I dumped from telenet, which only has this in the header:
Code:
-- MySQL dump 9.11
--
-- Host: mysql.XXXXX.com Database: XXXXX-db101
-- ------------------------------------------------------
-- Server version 4.0.27-log
--
-- Table structure for table `address_book`
Should I import just the text file with telenet into the empty db102? am I stuck with the name of the old database?
Or Simply change the name of my existing database db101 to TEMP.....create a new empty database with the same name db101..import from my saved file...download again with DROP table and hopefully not the "create database" part and upload into a new empty database db102 and restore the old database name from TEMP back to db101?
Bookmarks