How to upload catalog folder?

[Wanwan]

Hi all,

 

I have spend my effort in searching for guides to upload my prebuild catalog, but didn't get one that teaches how to transfer the catalog folder from XAMPP server to real web hosting server. Even the hosting company's technical supports has limited knowledge in this field.

 

So, now I need guides that could teach me how to reconfigure the mySQL database that is connect to real webhosting server's mySQL that uses phpMyAdmin instead of a connection to XAMPP. or anyother valuable information I should know to do the transferring, will help alot.

 

Thank you in advance

 

:rolleyes:

[♥Vger]

You upload your catalog to the root of your website via FTP.

 

If you are using XAMPP then go to http://localhost/phpmyadmin and locate the database you are using offline. Then click on the Export tab, and take a backup of your offline database as an sql file.

 

Go to your web hosting control panel and create a blank database, then go to phpMyAdmin and locate that new database and use the SQL tab to import the contents of the backup sql file into the new database.

 

Then you need to edit both configure.php files to work on your domain.

 

Vger

[Wanwan]

Hi Vger,

 

I've followed your instruction by exporting the database from ofline phpmyadmin, and saved in desktop as .sql file. When I try to import it to a new database created in web hosting control panel. An Error occured.

 

Error

 

SQL-query :

 

CREATE TABLE `address_book` (

`address_book_id` int( 11 ) NOT NULL auto_increment,

`customers_id` int( 11 ) NOT NULL default '0',

`entry_gender` char( 1 ) collate latin1_general_ci NOT NULL default '',

`entry_company` varchar( 32 ) collate latin1_general_ci default NULL ,

`entry_firstname` varchar( 32 ) collate latin1_general_ci NOT NULL default '',

`entry_lastname` varchar( 32 ) collate latin1_general_ci NOT NULL default '',

`entry_street_address` varchar( 64 ) collate latin1_general_ci NOT NULL default '',

`entry_suburb` varchar( 32 ) collate latin1_general_ci default NULL ,

`entry_postcode` varchar( 10 ) collate latin1_general_ci NOT NULL default '',

`entry_city` varchar( 32 ) collate latin1_general_ci NOT NULL default '',

`entry_state` varchar( 32 ) collate latin1_general_ci default NULL ,

`entry_country_id` int( 11 ) NOT NULL default '0',

`entry_zone_id` int( 11 ) NOT NULL default '0',

PRIMARY KEY ( `address_book_id` ) ,

KEY `idx_address_book_customers_id` ( `customers_id` )

)ENGINE = MYISAM DEFAULTCHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT = 7

 

MySQL said:

 

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '',

`entry_comp

 

do you know how to fix it? or anyone know how to fix it?

 

thank you

[Wanwan]

Hi,

In case anyone have same question, I got this fix. Bellow is the solution.

When you have one database in your station and want to upload it into your web hosting mySQL server, however, both has different version.

 

Steps

 

1. Open your phpMyAdmin and locate the database that you want to export

2. Click Export Tab and select the table or tables you want

3. Select mySQL bullet.

4. At the right column, locate SQL export compatibility: NONE

5. Change the None to something else. For example, I am using phpmyadmin version 2.6.3, but the web hosting mySQL server is using pypmyadmin 2.4.0, change the NONE to mySQL40, instead NONE. ( if you use same version, you can leave it NONE)

6. Select Save as file and finally click go

7. The file is now saved in your station. Make sure you know where the file is saved.

 

Now go to your web hosting website and get into control panel.

 

Create a new database and click SQL tab. Click on ?browse? button and then Click ?Go? button. Now your database is successfully transferred.

[Wanwan]

Need help in editing both configure.php

 

I have already ftp my catalog and database to web hosting now, but I try to open the configure.php from webhosting server, but fail to do so.

 

Now, I decided to pull both configure.php from my own station using XAMPP server and edit from there. However, I don't know what correct words should put in

 

define('HTTP_SERVER', ''); // eg, http://localhost - should not be empty for productive servers

 

define('HTTPS_SERVER', '');

 

define('HTTP_COOKIE_PATH', '');

 

and

 

define('DIR_FS_CATALOG', 'C:/XAMPP/apachefriends/xampp/htdocs/catalog/');

 

please help!!!