|
Fetch users from v6 db?
|
| Tubaplayer |
Posted on 21-07-2008 11:04
|
Newbie
Posts: 4
Joined: 16/10/2007
|
Hi!
Is there a way to get the user data from an existing v6 site to a new v7 site? Or do I have to make a new v6 site, import the user data from the old one, and then upgrade the new site to v7? I just want the user data, not all the other content..
P |
| |
|
|
| mojkan |
Posted on 21-07-2008 11:41
|
Member
Posts: 129
Joined: 27/05/2008
|
I've been thinking about the same.
Wouldn't it be possible to write a script that upgrades a database, without having to create an entire site each time  For us who run both v6 and v7 and want the test site (v7) to use for instance forum threads, posts and users from v 6, that would make the work much easier.
Maybe an infusion where you point to a database and the infusion converts the database to v 7 standards |
| |
|
|
| Tubaplayer |
Posted on 21-07-2008 11:47
|
Newbie
Posts: 4
Joined: 16/10/2007
|
Good idea, but not the same thing that I have in mind. I'm not talking about running the sites side by side, sharing info from the db. What I need is to be able to switch from the old v6 site to the new v7 site (currently running in a sub folder on the same domain), and bring all the user data (basically the user registration data and the profile info) to the new site. Permanently.
A bonus would be if I could import the photo album, but that's not so important. I can do that manually on one of many rainy days in Bergen (Norway's rainy city).
I don't need/want forum threads, posts, news, articles etc. |
| |
|
|
| Matonor |
Posted on 21-07-2008 12:19
|
Admin
Posts: 1026
Joined: 17/06/2004
|
Upgrading the site and then backing up & restoring the data you want is the easiest way. It takes 5 minutes so I doubt anyone would write a script to do that.
Impossible things are there to be made possible |
| |
|
|
| kneekoo |
Posted on 21-07-2008 12:30
|
Senior Member
Posts: 278
Joined: 20/01/2006
|
Tubaplayer, if all you want is to upgrade to v7 on your website then follow Matonor's advice. After that we can easily help you to empty your news, forum and the other tables. That's probably the smallest problem you could get into.
mojkan, why complicate your life with custom imports/exports? Try this:
1. Install the same v6 version you have on the first site to your second location.
2. Make a backup of your v6 (Admin Panel -> System Admin -> Database Backup) and keep it handy.
3. Copy all your files from your current site to the new one.
Now the next step would be to restore your database but it's very important that you give your saved tables a different prefix before continuing so you can have two separate sites running.
To rename your table prefixes you will have to open your SQL file in Notepad, Notepad2 etc (not Wordpad, Word or any other rich text editor) and start replacing the prefixes. This is as example:
Replace `fusion_ with `fusion7_
As you noticed, I only added a 7 but that's enough to make it different so we don't end up mixing data.
4. Login as a Super Administrator on your second website and go to Admin Panel -> System Admin -> Database Backup to restore your modified database backup.
5. Login through FTP to your website and edit your config.php file to update $db_prefix and DB_PREFIX. This way your new website will use the modified database you have just restored from your full export.
6. Get v7 and follow the readme instructions to migrate your new site to the latest version. That should be it.
|
| |
|
|
| Tubaplayer |
Posted on 21-07-2008 12:36
|
Newbie
Posts: 4
Joined: 16/10/2007
|
Thanks for your replies, much appreciated. Thing is, I have a v7 site that was originally supposed to be used just for testing stability and compatibility. While testing, I posted news, articles, links, pictures and so on. Now I'd like to keep all of this stuff in the new site, so a full export/import from the old site, followed by deleting news, articles etc. is not an option. But Matanor's suggestion is probably the best, if I make a bit of extra work of it. Here's my plan:
- set up a new 6.x.x site
- import db from old v6 site
- upgrade new v6 site to v7
- export user fields
- import user fields to current v7 site
- done |
| |
|
|
| TammyK |
Posted on 21-07-2008 13:27
|
Veteran Member
Posts: 501
Joined: 26/10/2005
|
Do the export then empty the tables you don't want to use. Then upgrade to v7. |
| |
|
|
| VoiceX |
Posted on 21-07-2008 15:21
|
Newbie
Posts: 5
Joined: 05/10/2006
|
how can i bring the only Users into v7?
I just wanna export Username, Userinfos, password, mail and rest of Users info. No news/articles/... |
| |
|
|
| Tubaplayer |
Posted on 21-07-2008 15:25
|
Newbie
Posts: 4
Joined: 16/10/2007
|
Read the thread.... That was my first question, and it has been properly solved.. If you read my last entry, I wrote down step by step how I'm going to do it. That's probably the easiest way. If you have a fresh install without any news, articles, forum posts and so on, you can import the entire database, and then delete everything you don't need.
Edited by Tubaplayer on 21-07-2008 15:27
|
| |
|
|
| mojkan |
Posted on 21-07-2008 15:53
|
Member
Posts: 129
Joined: 27/05/2008
|
kneekoo wrote:
Tubaplayer, if all you want is to upgrade to v7 on your website then follow Matonor's advice. After that we can easily help you to empty your news, forum and the other tables. That's probably the smallest problem you could get into.
mojkan, why complicate your life with custom imports/exports? Try this:
1. Install the same v6 version you have on the first site to your second location.
2. Make a backup of your v6 ( Admin Panel -> System Admin -> Database Backup) and keep it handy.
3. Copy all your files from your current site to the new one.
Now the next step would be to restore your database but it's very important that you give your saved tables a different prefix before continuing so you can have two separate sites running.
To rename your table prefixes you will have to open your SQL file in Notepad, Notepad2 etc ( not Wordpad, Word or any other rich text editor) and start replacing the prefixes. This is as example:
Replace `fusion_ with `fusion7_
As you noticed, I only added a 7 but that's enough to make it different so we don't end up mixing data.
4. Login as a Super Administrator on your second website and go to Admin Panel -> System Admin -> Database Backup to restore your modified database backup.
5. Login through FTP to your website and edit your config.php file to update $db_prefix and DB_PREFIX. This way your new website will use the modified database you have just restored from your full export.
6. Get v7 and follow the readme instructions to migrate your new site to the latest version. That should be it.
I already did that And it works like a charm. I admit I was a bit lazy in my thoughts before. I will only have to do this one time when it's time to convert to v7. Until then I don't really need to keep my test v7 site up to date.
Yep yep, keep up the good work you do here
Tubaplayer wrote:
Thanks for your replies, much appreciated. Thing is, I have a v7 site that was originally supposed to be used just for testing stability and compatibility. While testing, I posted news, articles, links, pictures and so on. Now I'd like to keep all of this stuff in the new site, so a full export/import from the old site, followed by deleting news, articles etc. is not an option. But Matanor's suggestion is probably the best, if I make a bit of extra work of it. Here's my plan:
- set up a new 6.x.x site
- import db from old v6 site
- upgrade new v6 site to v7
- export user fields
- import user fields to current v7 site
- done
That is exactly how I did it! And it works very well. However, I guess you will lose those news etc you have put in your v7 test site, if you also want the news etc from your old site. Unless you are able to chose specific information to restore from phpMyadmins (but I don't think you can merge the databases like that).
Also sorry for hi-jacking your thread, at the beginning I thought we hade the same ide
Edited by mojkan on 21-07-2008 16:01
|
| |
|
|
| VoiceX |
Posted on 21-07-2008 18:08
|
Newbie
Posts: 5
Joined: 05/10/2006
|
thx, i solved it myself by exporting fusion_users and fusion_user_groups. Took the inserts, added the fields user_admin_password and user_threads.
Needed 15 minutes in comparing the old and the new table and 5 minutes in doing the work in phpMyAdmin. |
| |
|
|
| googlebot |
Posted on 21-07-2008 19:01
|
Veteran Member
Posts: 644
Joined: 27/05/2008
|
You do know you can select the tables that you back up, don't you? That is, you can back up only PREFIX_users if you want..
|
| |
|
|
| kneekoo |
Posted on 21-07-2008 19:10
|
Senior Member
Posts: 278
Joined: 20/01/2006
|
Well... he does know.
VoiceX wrote:
thx, i solved it myself by exporting fusion_users and fusion_user_groups. Took the inserts, added the fields user_admin_password and user_threads.
|
| |
|
|
| mojkan |
Posted on 21-07-2008 20:59
|
Member
Posts: 129
Joined: 27/05/2008
|
googlebot wrote:
You do know you can select the tables that you back up, don't you? That is, you can back up only PREFIX_users if you want..
Yep But I miss the fact in phpMyadmins to be able to break out one table to restore out of an entire database like you can do using restore from within your php-fusion site. |
| |
|
