How to create my own quickstart.zip for Magento web store that have been modified?

Hi victorlai,

Yes you can, with a database tool like phpmyadmin you can export your database to a sql file name sample_data.sql, open that file to replace all your table prefix by #__ and finally under the root store/sql folder you replace the sample_data.sql file there by the exported file !

I’m blur with your explanation.
Can you show me step by step to do it?

Hi victorlai,

Yes you can, with a database tool like phpmyadmin you can export your database to a sql file name sample_data.sql, open that file to replace all your table prefix by #__ and finally under the root store/sql folder you replace the sample_data.sql file there by the exported file !

Hi Victorlai,

i think it’s pertty much clear, let me know which parts you don’t understand !

BELOW IS THE STEPS THAT I TOOK BUT IT CAN’T WORK. CAN U PLS GIVE ME ADVICE? THANKS.

Purpose:
To Move Magento Online Store From demo.onemelaka.com/OnlineShopping/firecs
To demo.onemelaka.com/testing

———————————————————————————————--

Download and Transfer Magento Files

1) CPanel -> File Manager -> Directory Selection -> SELECT Document Root for: demo.onemelaka.com -> CLICK Go
2) DOUBLE CLICK OnlineShopping FOLDER -> DOUBLE CLICK firecs FOLDER -> CLICK Select all TO SELECT ALL MAGENTO FILES -> CLICK Compress -> SELECT Compress Type (Zip Archive) -> CLICK Compress File(s) BUTTON
3) SAVE AS firecs.zip
4) Using FTP program UPLOAD firecs.zip to demo.onemelaka.com/testing/
5) EXTRACT firecs.zip
6) GO TO app/etc/local.xml CHANGE the below:
<dbase><![CDATA[onemelak_firecs]]></dbname>
TO
<dbase><![CDATA[onemelak_firecs_testing]]></dbname>

————————————————————————————————

Create New Database

1) CPanel -> MySQL Databases
2) New Database: onemelak_firecs_testing

————————————————————————————————--

Export MySQL Database (onemelak_firecs.sql)

1) CPanel -> phpMyAdmin -> CLICK THE DATABASE THAT NEED TO EXPORT (onemelak_firecs)
2) CLICK Export BUTTON ON THE TOP
3) SAVE IT AS onemelak_firecs.sql

——————————————————————————————————--

Import MySQL Database

1) EDIT onemelak_firecs.sql WITH NOTEPAD TO CHANGE Database: ‘onemelak_firecs’ TO Database: ‘onemelak_firecs_testing’
2) SAVE onemelak_firecs.sql
3) CPanel -> phpMyAdmin -> SELECT & CLICK MySQL Database onemelak_firecs_testing
4) CLICK Import BUTTON
5) SELECT onemelak_firecs.sql & CLICK Go BUTTON

————————————————————————————————-

DONE!

BUT

When I go to URL: demo.onemelaka.com/testing, it redirect to URL: demo.onemelaka.com/OnlineShopping/firecs

WHICH STEPS HAVE BEEN WRONG?

hi victorlai,

I think you would need to change some path in the core_config_data table, Follow this guide for more details.

hi victorlai,

I think you would need to change some path in the core_config_data table, Follow this guide for more details.

I already change the path for web/unsecure/base_url and web/secure/base_url
But still not working.

you can start again by following the guide from the beginning to see if that helps