site data no update after import database
Permalink
Hi, i just move my site from local to live.
I direct install c5 at my new hosting using "Installatron Applications Installer".
I move theme folder i had edited to my site.
I import database which i export form localhost.
But my site still keep no update, the data still keep:
"Welcome to concrete5!
Content Management is easy with concrete5's in-context editing. Just login and you can change things as you browse your site."
I try clear cacha, it din work.
What i have miss out? Please help on me..
I direct install c5 at my new hosting using "Installatron Applications Installer".
I move theme folder i had edited to my site.
I import database which i export form localhost.
But my site still keep no update, the data still keep:
"Welcome to concrete5!
Content Management is easy with concrete5's in-context editing. Just login and you can change things as you browse your site."
I try clear cacha, it din work.
What i have miss out? Please help on me..
Once you have solved your actual copy/clone issue, please bear in mind:
http://www.concrete5.org/documentation/how-tos/developers/organise-...
http://www.concrete5.org/documentation/how-tos/developers/organise-...
Hi madeforspace.
Do you means clear cacha c5 in local?
I have go through the how - to page and follow the step but still can't get it work.
Is it i use auto installer at cpanel to direct install?
Do you means clear cacha c5 in local?
I have go through the how - to page and follow the step but still can't get it work.
Is it i use auto installer at cpanel to direct install?
Did you import the database in a new database you made? Or did you imported the database in the new one of C5 itself?
Yes, i did. I import database from my local to live also
but it din show any update
but it din show any update
Just make it sure that you are in the right page. Try to open your Configs site.php and check the DB name. Then check the DB where you import the data. Also you can do a trick to test whether you are in the right path. Just comment out the site.php code & run the site. If it doesn't shows error then you are in the wrong DB.
Rony
Rony
To move a site from local to a live server, you DO NOT install a fresh copy of Concrete!
On your local site, Disable Pretty urls and turn off all caching, Clear the cache,
Then copy your existing local Concrete files and folders via ftp to the live server root space,
Next you create a new blank database on your live server and import your database file used by your local server, HOWEVER you must make sure the database file table names are NOT lowercase, they must be Capitalized,
In your case I suspect that the database HAS been successfully imported but because they are lowercase table names they are not being used by your fresh copy of Concrete,
In other words you have duplicated your database tables by having lowercase and Capitalised..
When you have successfully setup your database you must edit your config/site.php file to reflect the new database details.
On your local site, Disable Pretty urls and turn off all caching, Clear the cache,
Then copy your existing local Concrete files and folders via ftp to the live server root space,
Next you create a new blank database on your live server and import your database file used by your local server, HOWEVER you must make sure the database file table names are NOT lowercase, they must be Capitalized,
In your case I suspect that the database HAS been successfully imported but because they are lowercase table names they are not being used by your fresh copy of Concrete,
In other words you have duplicated your database tables by having lowercase and Capitalised..
When you have successfully setup your database you must edit your config/site.php file to reflect the new database details.
I think I can guess now what's wrong.
In your config/site.php, did you use localhost?
Because that's likely not to work. Instead it should be an IP-adres of the server or the url like mysql.sitename.com
Ask your host what to put there.
In your config/site.php, did you use localhost?
define('DB_SERVER', 'localhost');
Because that's likely not to work. Instead it should be an IP-adres of the server or the url like mysql.sitename.com
Ask your host what to put there.
1. In you hosting root folder upload all your C5 files via ftp.
2. Create a new database in your hosting account and a new database user.
3. Import your local database into the new database.
4. Update your site.php with your new database details, it can be found in /config/site.php
Before you move make sure your C5 cache is cleared and you have turned off Pretty URL's (re-enable them once you have successfully installed.
There is a HowTo on this topic in the documentation section of this site, best to read that first to make sure I have not missed anything.
Hope that helps.