Moving DATABASE(Products) to new Prestashop

[sulupa]

I am desparate for some urgent assistance. I had a temp domain (georgian.*) where I'd set up my shop.
I want to move it to another domain (Tentroium-shop.*) in the same hosting.
litterally I've faced up too many probs there, so I don't mind moving all things, and for now I just want to move my products to new INSTALL of prestashop.
I've tryed this with myphpadmin but didn't successed. ( With Export/Import commands)
what am i supposed to do?
is it enough to use only MyPHPAdmin or I should also set MySQL database from "MySQL Database Wizard" setting from cPanel?
but the problem I see is that databases has different prefixes, does it matter?
I'm using cPanel for controlling.
I'm in a such difficult situation, I'd be happy to hear any kind of suggestion.
Thanks in advance.

[sulupa]

Pinned Up. PLease, anyone who can help, suggest me anything to do it right.

[Mark Hesketh]

Hi Sulupa.,

You're on the right track, you should be able to move your products across using PHPMyAdmin or similar by exporting the data, and then importing it to your new database.

Could you give a run through of what you exported, and what the problem was exactly?

I suspect your problem is that the database table relationships ties so many different tables together.

If your products had tags, attributes, combinations, sales, images, categories etc, all of these tables would have to be moved over in addition to the ps_product_ tables.

Is there a reason you're wanting to only move the products and not the entire database?

Mark

[sulupa]

Thanks for response, Mark.
Well, for the first time, I've backuped all my data and then restore it on a new cPanel account. ( all these Backup and Restore I've done with cPanel tools ("Backup Wizard"), so I didn't know about MyPHPAdmin, how should I've been supposed to work with it).
So, all the content from old public_html are moved to new tentorium-shop.* public_html, so as I assumed there must have been the problem of databases.
http://tentorium-shop.ge/ is the adress of web, and it says: Link to database cannot be established. So that's truly problem of database connection.
P.S. I've changed config files
I've tryed to backup MySQL database from cPanel tool "Backup Wizard" and restore it on a new account, but nothing happened.
I've also tryed to do it with my MyPHPadmin. But couldn't make it work.
I suspect that problem is the database prefix, as on a old account it was georgian_* , and a new one has shop_*. Can it be problem? what do you think? or it doesn't matter?

I really NEED help, as I'm running out of time. I can also give away cPanel access for person who doesn't mind to help me.
Thanks in advance.

[sulupa]

PINNING UP

[shokinro]

I suspect that problem is the database prefix, as on a old account it was georgian_* , and a new one has shop_*. Can it be problem? what do you think? or it doesn’t matter?

You have to change following setting file to change to your database on your new server.

YourSiteRoot/config/settings.inc.php

The following lines need to be changed

define('_DB_SERVER_', 'your db server');
define('_DB_NAME_', 'your new db name');
define('_DB_USER_', 'your new db user');
define('_DB_PASSWD_', 'your new db user password');

[Asenar]

Hi,

you can use Tools > DB Backups and then use the resulted files in phpmyadmin.

If you still have issues, feel free to call our support