mbc_3 Posted October 19, 2021 Share Posted October 19, 2021 I was wondering if anyone knew where 30 Bees stores information like customers, products, etc. so I can try to restore my store from before the upgrade to 1.3 (long story, mostly it was my fault for not backing up correctly). I did a fresh installation and have a working store, but would prefer to have my customer info / products, if possible. I have a backup of all the files from the old installation (essentially just the snapshot of the directory on my web host), and my MySQL database (I used a different prefix for this new installation, but it's the same database). If anyone can point me in the right direction, I'd appreciate it. Link to comment Share on other sites More sharing options...
led24ee Posted October 19, 2021 Share Posted October 19, 2021 This info is in database. That's why database are invented. Way different is thing when You need put data from one base to another. And if prefix is also changed then it depend what sql manager is in use. In some cases You need to restore old base and then you can copy from on base to another. But it isn't catastrophic until you have all this data. Link to comment Share on other sites More sharing options...
mbc_3 Posted October 19, 2021 Author Share Posted October 19, 2021 I have PHPMyAdmin, Can you either tell me how to take the data from the old prefix and copy it into the new prefix, or point me in the direction of somewhere I can read about this? Link to comment Share on other sites More sharing options...
led24ee Posted October 20, 2021 Share Posted October 20, 2021 I don't understand what's wrong with people. There's tons of material in internet. Almost every software contains user manual and You ask " point me in the direction of somewhere I can read about this ?" Link to comment Share on other sites More sharing options...
datakick Posted October 20, 2021 Share Posted October 20, 2021 5 hours ago, mbc_3 said: I have PHPMyAdmin, Can you either tell me how to take the data from the old prefix and copy it into the new prefix, or point me in the direction of somewhere I can read about this? I believe the easiest solution for you is to just tall your store to use old prefix. To do that, edit file /config/settings.inc.php and change value for define('_DB_PREFIX_', 'tb_'); for example to define('_DB_PREFIX_', 'ps_'); Then go to core updater and check database differences. If there are some critical changes, apply fix. Please backup your database before. If this prefix changing is not the right approach for you, for some reason, you will have to copy every table independedly. Use sql like this for every table (ps_product is source, tb_product is target) truncate tb_product; insert into tb_product select * from ps_product; If the columns or their position are different, you will have to enumerate all fields as well: insert into tb_product(id_product, id_supplier, id_manufacturer,.....) select id_product, id_supplier, id_manufacturer,..... from ps_product; Very tedious task 2 Link to comment Share on other sites More sharing options...
mbc_3 Posted October 20, 2021 Author Share Posted October 20, 2021 (edited) Thank you so much! That's all very helpful, I appreciate it. I'm going to try this later today. Thank you for all the work you do! EDIT: Changing the prefix worked perfectly! Thank you again! Edited October 21, 2021 by mbc_3 updated info Link to comment Share on other sites More sharing options...
JoannPaynen Posted October 21, 2021 Share Posted October 21, 2021 (edited) You explain everything so clearly, thank you for such a detailed description!!! Edited October 21, 2021 by JoannPaynen Link to comment Share on other sites More sharing options...
musicmaster Posted October 21, 2021 Share Posted October 21, 2021 On 10/20/2021 at 7:39 AM, datakick said: If this prefix changing is not the right approach for you, for some reason, you will have to copy every table independedly. Use sql like this for every table (ps_product is source, tb_product is target) truncate tb_product; insert into tb_product select * from ps_product; If the columns or their position are different, you will have to enumerate all fields as well: insert into tb_product(id_product, id_supplier, id_manufacturer,.....) select id_product, id_supplier, id_manufacturer,..... from ps_product; Very tedious task If you need to do that kind of things you can better use my tool Copy_shopdata. It handles such problems for you. But in this case it is very likely not needed. 1 Link to comment Share on other sites More sharing options...
nickz Posted October 23, 2021 Share Posted October 23, 2021 On 10/20/2021 at 12:23 AM, led24ee said: There's tons of material in internet. That is the very problem. Due to the financial motivation the Internet provides we have 90% useless info. It costs a ton of time to search thru it. A chance for forums to have a second awakening. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now