Solved

Moving users to a new Moodle Server

Posted on 2011-03-01
6
565 Views
Last Modified: 2012-05-11
How would I move users accounts, complete with password from one moodle instance to another. I have full admin access to both moodle and the mySQL backed database which is based on shared web hosting .
0
Comment
Question by:weegiraffe
  • 3
  • 3
6 Comments
 
LVL 10

Accepted Solution

by:
NetExpert-Warszawa earned 500 total points
ID: 35014574
Copy all SQL tables with names starting with mdl_user_
0
 
LVL 10

Expert Comment

by:NetExpert-Warszawa
ID: 35014578
... starting with mdl_user (mdl_user itself is the most important :) )
0
 

Author Comment

by:weegiraffe
ID: 35033316
Should this be copy the tables, copy the records from the table. I want to ensure that existing records remain in tact
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 10

Expert Comment

by:NetExpert-Warszawa
ID: 35033866
It does not matter. You can:
delete the tables,
dump the old ones with a structure and data,

run the dump script on the new installation

or
delete all records from the tables,
dump the old ones with data only,
run the dump script on the new installation

Before you do anything, make a complete backup of both databases. Just to be able to revert.
0
 

Author Comment

by:weegiraffe
ID: 35068348
Thanks, will a few days before I can attempt this.
0
 

Author Closing Comment

by:weegiraffe
ID: 35354250
Sorry for the delay in getting back to this, life gets busy sometimes
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Drupal 5.x currently does not have a production-ready patch bundle to allow for split read & writes for a MySQL master/slave replication setup. After reading a open discussion/thread on the Drupal site (http://drupal.org/node/147160 (http://drupal.o…
Read about how to choose the best possible content marketing agency to suit your needs. Content marketing has become an integral part of running a successful tech business, so it is wise to be informed.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now