Youjoomla Support Forums (
-   Anything Goes (
-   -   trying to restore a database (

smsperty 04-12-2009 04:54 PM

trying to restore a database
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`

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

neo 04-13-2009 07:45 AM

get , migrator component

Migrator from 1.0 to 1.5 - Joomla! Extensions Directory

smsperty 04-13-2009 10:38 AM

Thanx neo,

My problem is not with the migration.
I m explaining again.
My site is To test if the migration will not couse me any problem I thought to create but I cant restore the database of

neo 04-13-2009 02:59 PM

1 Attachment(s)
got you , ok when exporting you MUST check the box that says "Drop Table if Exists"

smsperty 04-19-2009 04:45 PM

Teyd even this but with no success.
maybe i will try to copy the tables one by one

neo 04-20-2009 10:29 AM

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

ameenudeen 10-13-2009 08:09 AM

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

All times are GMT -4. The time now is 11:40 PM.

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