איך מעלים SQL שבניתי ב LOCALHOST

[avrilev]

שלום לכולם,

 

איך אני מעלה SQL ממה שבניתי בלוקלהוסט?

[yaniv14]

Export your db and import to the live server.

If you will use different db name and/or user name/password, you will need to modify it in 'config/settings.inc.php'.

Once done, modify ps_shop_url in the newly imported db.

Delete old cache.

[avrilev]

Thanks for your reply.

I though need to know some other things as well:

1. how do I delete the old cache?

2. can I import the new DB data directly, or should I first destroy the old DB on my server? (I mean drop all tables first and than do the import?)

 

Thanks again,

Avri

[yaniv14]

I think that the import will do the job for you, but I recommend opening a new clean db just for that and then doing the import on a clean, no tables db.

 

inside 'cache/smarty' you have 2 folders, cache & compile, delete the content of both folder beside the index.php file in both (don't delete the folders).

 

Yaniv M