Creating database export from local host
Permalink
Hi, I've created a WAMP stack and developed a themed concrete5 website on my local machine.
I'm now trying to move it to a hosting server.
When I launch my stack to run on the local website, I have an option to access built-in management tool pphMyAdmin.
Is this the place where I need to be to export my database??
Because I cant find it in there.
Please can someone tell me where I should be looking?
I'm now trying to move it to a hosting server.
When I launch my stack to run on the local website, I have an option to access built-in management tool pphMyAdmin.
Is this the place where I need to be to export my database??
Because I cant find it in there.
Please can someone tell me where I should be looking?
Thank you for getting back to me.
I've looked in my local root\config\site.php and identified database as:- define('DB_DATABASE', 'bitnami_concrete5')
However, this database isn't listed in phpMyAdmin!
I have two listed, one empty one called "test" and anther called
"information_schema"
An idea what I'm doing wrong?
Thank you
I've looked in my local root\config\site.php and identified database as:- define('DB_DATABASE', 'bitnami_concrete5')
However, this database isn't listed in phpMyAdmin!
I have two listed, one empty one called "test" and anther called
"information_schema"
An idea what I'm doing wrong?
Thank you
Can you get to the phpmyadmin login screen?
Use the username and password found in the site.php to login to phpmyadmin instead of the root user. Then you should be able to see the bitnami_concrete5 DB and be able to export it.
You should also be able to create a DB backup you can use to import on the live server at Dashboard/System & Settings/Backup Database
Use the username and password found in the site.php to login to phpmyadmin instead of the root user. Then you should be able to see the bitnami_concrete5 DB and be able to export it.
You should also be able to create a DB backup you can use to import on the live server at Dashboard/System & Settings/Backup Database
Thank you so much. I see it now, and I'll carry the export. Great help!!
You may find my Backup Voodoo addon useful for moving sites too and from online/offline. Also integrates with the case conversion addon.
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
Once you have plain database, you select it and search the buttom "import", then locate .sql file (this, you have created via c5 backup tool on local machine).
Don't forget to set character coding, same you are using on localhost.
The second thing is, that you must upload your files to server with exact folder structure.
The last important part is to change [root]/config/site.php settings which will match your online server DB (login/db/pw).
Ask if you need more backup ;)