| Author |
Message |
Miro
Joined: 05 Apr 2006
Posts: 43
|
|
 Import/export mysql |
 |
My site consist more than 300 articles and now I want to change my web hosting. I wonder how can I move, Import and export my database/mysql from one server to on other without any problems?
|
|
| Tue May 16, 2006 7:55 am |
  |
 |
Guest
|
| |
|
Please login to hide the ads.
|
|
|
|
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
| |
|
Admin panel -> Main -> backup (the link is below system check/statistics)
Download the backup and import it using phpmyadmin.
You have to use phpmyadmin because CuteNews.RU doesn't have an import function.
|
|
| Tue May 16, 2006 10:36 am |
|
|
scottdallas
Joined: 04 May 2006
Posts: 2027
Location: US |
|
| |
|
does that mean you can't use the 'convert' option for transferring your existing cutenews.ru information like when you upgrade from standard cutenews to this cutenews?
_________________
www.scodal.com is an example of cnr as a social forum - www.scottdizzle.com is an example of cnr as a personal website to share whatever cool stuff i feel like. i have another, but it's nsfw. pm me  |
|
| Fri May 26, 2006 1:19 am |
  |
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
| |
|
You can convert Cutenews to CuteNews.RU, CuteNews.RU (txtSQL) to CuteNews.RU (MySQL) using the script.
And you can backup your MySQL database using the script. But you have to restore your MySQL database using phpmyadmin because CuteNews.RU doesn't have an import function.
|
|
| Mon May 29, 2006 7:07 pm |
|
|
Miro
Joined: 05 Apr 2006
Posts: 43
|
|
| |
|
Hello,
I've managed to export my database but it has been very difficult to import the file to onother webhotel. could you please guidance me more detaield haw do I do in phpmyadmin to import my databas?
|
|
| Mon Jun 05, 2006 6:24 am |
|
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
| |
|
Go to phpmyadmin, select your database in the dropdown on the left, click on "Import" in the main window, press the browse button, browse to your backup file and press "Go". That should be it.
|
|
| Mon Jun 05, 2006 7:42 pm |
|
|
Miro
Joined: 05 Apr 2006
Posts: 43
|
|
| |
|
actualy it's the problem. I don't see any "Import" in the main page or any place 
I chose the database and have this links avalible: Structre - SQL - Export - make a question "this links is in swedish and I've translated".
|
|
| Mon Jun 05, 2006 9:04 pm |
|
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
| |
|
Strange. 
Anyway, click on SQL and copy and paste the content of the backup file into the window. Then click on OK.
I never tested it but it might work too.
|
|
| Tue Jun 06, 2006 7:22 pm |
|
|
Mania
Joined: 03 Feb 2007
Posts: 107
|
|
| |
|
ok with export and import is clear 
but what is with change domain name to.
which field in mysql is for base url? or Path to main page: & Path to the Script:?
thanks
|
|
| Wed Nov 26, 2008 10:12 pm |
|
|
FI-DD
Admin
Joined: 22 Sep 2005
Posts: 2857
Location: Germany |
|
| |
|
That's not saved in the database but in data/config.php.
|
|
| Thu Nov 27, 2008 10:32 pm |
|
|
azn_romeo_4u
Joined: 18 Sep 2008
Posts: 81
|
|
| |
|
If you are using cpanel, just log into the cpanel and download the mysql db. Then when you switch host, and hopefully the host has cpanel, should most do, just upload the backup file and it should worl.
|
|
| Tue Dec 02, 2008 2:09 am |
|
|
|
