PrestaShop Forum

The best place in the world to ask questions about PrestaShop and get advice from our passionate community!

PrestaShop Forum

Jump to content

 

[Solved] PrestaShop database tables prefix

8 replies to this topic
#1
cosmebio

    PrestaShop Newbie

  • Members
  • Pip
  • 13 posts
Hi,

Once again stuck in step 3 of PrestaShop Installation process.

I went through the Database configuration and I was able to verify it successfully.

I also was successful in the Email Set Up step.

But, when I press the NEXT button I get the following error message:

Quote

A Prestashop database already exists, please delete it or change the prefix.



The default prefix for PrestaShop database tables is

Quote

ps_



What I am supposed to do to get through step 3 of the PrestaShop installation process?

Thanks,

José

#2
cosmebio

    PrestaShop Newbie

  • Members
  • Pip
  • 13 posts
I sorted it out myself again.

José

#3
Rotor

    PrestaShop Newbie

  • Members
  • Pip
  • 7 posts

From 1240332390:

I sorted it out myself again.

José


Maybe you should also say how did you solved the issue. That would help others, don't you think?

#4
Dellytoe

    PrestaShop Newbie

  • Members
  • Pip
  • 4 posts
Hai guys, I got same problem as mention above. could you please inform me how to solve this problem? thanks

#5
rocky

    PrestaShop Superstar

  • US Moderators
  • 9988 posts
This error occurs when you try to install Prestashop twice with the same database prefix. You need to log in to phpMyAdmin and delete all the existing database tables with that prefix, or if you want to keep that Prestashop installation and create a second one in the same database instead, you should provide a different database prefix.
Check out Nethercott Constructions for PrestaShop guides and modules. Like us on Facebook for news updates.

#6
Dellytoe

    PrestaShop Newbie

  • Members
  • Pip
  • 4 posts
Thanks for your info. I've decided to delete all installed prestashop than reload again. I started from the beginning and installed satisfactorily. thanks.

#7
classyjoeses

    PrestaShop Newbie

  • Members
  • Pip
  • 3 posts
I had to delete all my prestashop files on my computer because I made some mistakes and needed to go back to original settings (minus all my meddling).

I've reinstalled Prestashop again and I want to restore the old database.

How do I 'drop the database in'? on step 3 as opposed to deleting it?

#8
rocky

    PrestaShop Superstar

  • US Moderators
  • 9988 posts
There is no option in the installer to do that. The best you can do is choose the "Clean install" option, then import your tables using phpMyAdmin.
Check out Nethercott Constructions for PrestaShop guides and modules. Like us on Facebook for news updates.

#9
KyGoogleGuy

    PrestaShop Newbie

  • Members
  • Pip
  • 6 posts
Please help, I am Stuck! - During the installation process -

"A Prestashop database already exists, please drop it or change the prefix." Can't get to the next step.

I have tried changing the Database engine from InnoDB to MyISAM (No Luck.) Created new database(s) several times. (No Luck.) Tried new database (No Luck.) Reading the forums it appears that others have had this problem, but no solutions posted.