coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Installation & Setup => Topic started by: crashoverride on September 30, 2005, 07:26:45 PM

Title: How to create e new table into the database??
Post by: crashoverride on September 30, 2005, 07:26:45 PM
I delete a table into the database . How to create  e new table  into the database'??I have one copy  backup for this table( have exported this table ).How to recreate this table?? thank ypu
Title: Re: How to create e new table into the database??
Post by: Nibbler on September 30, 2005, 07:27:44 PM
Import the backup using phpmyadmin.
Title: Re: How to create e new table into the database??
Post by: crashoverride on September 30, 2005, 07:33:31 PM
Quote from: Nibbler on September 30, 2005, 07:27:44 PM
Import the backup using phpmyadmin.
yes i have imported Imported  the backup using phpmyadmin and i se  that error : #1146 - Table '********_******.***_groups' doesn't exist . ????? Help me.
Title: Re: How to create e new table into the database??
Post by: crashoverride on September 30, 2005, 08:04:06 PM
Quote from: crashoverride on September 30, 2005, 07:33:31 PM
Quote from: Nibbler on September 30, 2005, 07:27:44 PM
Import the backup using phpmyadmin.
yes i have imported Imported  the backup using phpmyadmin and i se  that error : #1146 - Table '********_******.***_groups' doesn't exist . ????? Help me.


Up
Title: Re: How to create e new table into the database??
Post by: Stramm on September 30, 2005, 08:28:21 PM
then you have imported only data and not the structure
Title: Re: How to create e new table into the database??
Post by: Joachim Müller on October 01, 2005, 10:48:41 AM
probably means that your dump is incomplete and therefor useless unless you know your way around. Take a look at coppermine's sql folder - the queries needed to create blank tables are there. You will have to know what you're doing though. I recommend getting professional help, or starting from scratch and restoring as much as you can from your dump and files. For details, you would have to post what table you deleted.