Hello there! Welcome to Youjoomla Support Forums

We are Web Development Company specializing in Joomla Templates , Joomla Extensions and WordPress Themes development . You are not able to see some forum threads due to your memberhip level. To unlock all forums and special customer support please take few moments to signup . If you are just searching for free joomla templates , or free joomla extension support simply head to our Free Joomla Support forums and open a new thread. Our moderators will help you as soon as possible. To spead up the response time please take few seconds and go over forum rules

Have fun!

trying to restore a database

04-12-2009, 04:54 PM
# 1 (permalink)
smsperty
I want to migrate from jommla10 to 1.5 and I thought I can do some test by coping my site and installing it to a subdomain.
I did as follows
Dowloaded all the files and uploaded to the new space then trying to restore the database.
I use jombackup.systembot to back up mysite.
When i try to import my database I get this error:


SQL query:

#
# MySQL database dump
# Created by MySQL_Backup class, ver. 1.0.1
#
# Host: ***********
# Generated: Apr 11, 2009 at 00:13

# MySQL version: 5.0.51a-log
# PHP version: 5.2.9
#
# Database: `db*******`
#
#
# Table structure for table `jos_banner`
#

DROP TABLE IF EXISTS `jos_banner`
MySQL said:

#2013 - Lost connection to MySQL server during query

[ Back ]

I did it with different dayly database and get the same error.

Then tryed to export my database from my phpmyadmin and used this database but whe I import it i get a blank page.

Any suggestion please
04-13-2009, 10:38 AM
# 3 (permalink)
smsperty
Thanx neo,

My problem is not with the migration.
I m explaining again.
My site is www.mysite.com. To test if the migration will not couse me any problem I thought to create www.new.mysite.com but I cant restore the database of www.mysite.com.
04-13-2009, 02:59 PM
# 4 (permalink)
neo
got you , ok when exporting you MUST check the box that says "Drop Table if Exists"
Attached Images
File Type: jpg droptable.JPG (13.3 KB, 6 views)
04-19-2009, 04:45 PM
# 5 (permalink)
smsperty
Teyd even this but with no success.
maybe i will try to copy the tables one by one
04-20-2009, 10:29 AM
# 6 (permalink)
neo
no no , the sql error you are getting says that the tables exist and canot be populated , it is because you have not used drop table if exists, it most work with that command
10-13-2009, 08:09 AM
# 7 (permalink)
ameenudeen
Hi this might be because of run time error, try to increase your max execution time and size in php in and then try to restore your database
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

Members Login

Username
Password