Removed local database from phpmyadmin by mistake

[Soulkreed]

Can someone please help me,
I have deleted my local zen cart database tables in the phpmyadmin section and can no longer the tables ( zen cart {--} ) in the database drop down tab in the top left, the actual store ( local ) is all still there i just can't see it in phpmy admin or when i click on the store front link it say's and it also says the same thing in the admin section as well. ( see below )

1146 Table 'zen cart.configuration' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

It say's zen cart is there but it doesn't have any tables anymore..
Any thoughts?

[tino.schlegel]

Well I you have deleted all tables, its basically all gone. Do you have a backup that you can import? Otherwise you can start from scratch and setup you Zencart again.

No backup, no way to get your data back. There is no undelete in MYSQL.

[Soulkreed]

I have back ups but how do i import it back into phpmyadmin, i have tried but to no avail?

[RodG]

I have back ups but how do i import it back into phpmyadmin, i have tried but to no avail?

What format are your backup files in? An SQL export, or a local copy of the entire database?

If a local copy of the database you'll first need to export the data as 'SQL' (locally) and then usue the phpMyAdmin 'import' feature at the server.

If your backup is in SQL format on the server, then simply re-import the data.

Cheers
Rod

[Soulkreed]

Hi,
can you tell me do i use the phpmyadmin on my local server to import/re-install copy of database/zencart ? ) if it is the phpmyadmin local i cannot find the import button, there is one in the phpmyadmin on my dot easy server though. I am unsure of the process itself, can you please tell me what to do? If i do import using dot easy server, do i just click on import and go find the folder/file and import it, if so how do i get it back onto my local computer if i have uploaded it to my server?

The back up i have is SQL format.

Cheers.

[koesbong]

in phpmyadmin, re-create the database for your zencart. then on one of the tabs on top, there's a tab called Import. Click that and then select the backup sql file, then import.

[RodG]

The back up i have is SQL format.

IF your backup is in SQL (text) format you'll only need to go to your dot easy account, start phpmyAdmin. select the 'import' tab, browse to your SQL backup, then press the 'go' button.

can you tell me do i use the phpmyadmin on my local server to import/re-install copy of database/zencart ? )

Importing your backup data into your local server isn't going to help you restore the data that you deleted on your dot easy server.

If i do import using dot easy server, do i just click on import and go find the folder/file and import it,

Yes.

if so how do i get it back onto my local computer if i have uploaded it to my server?

You'd use the same backup file that you plan to use to restore your dot easy server.

I really can't understand why you'd be needing to do this though, unless you managed to delete the data from both servers ?????

Rgds
Rod