1. The forums will be archived and moved to a read only mode in about 2 weeks (mid march).

Simple auth YAML to MySQL

Discussion in 'Plugin Help' started by VCraft, Dec 16, 2016.

  1. VCraft

    VCraft Witch

    Messages:
    60
    GitHub:
    VCraftMCPE
    Is there a way to transfer MySQL database data to MySQL? I have like 10k registered players
     
  2. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
    PEMapModder once wrote a gist that executes this transfer, but it did not work properly and needed fixing. Search through his gists to find it, or search #pocketmine IRC on botbot; there was a link to that gist on IRC too.
    I would however recommend you to use alternatives. For wxamp, HereAuth is much better than SimpleAuth in terms of performance especially with mysql data provider, and it has an /import command for importing database from SimpleAuth (you have to provide details).
     
    Muqsit and applqpak like this.
  3. HBIDamian

    HBIDamian HBIDamian Staff Member

    Messages:
    365
    GitHub:
    HBIDamian
    applqpak likes this.
  4. VCraft

    VCraft Witch

    Messages:
    60
    GitHub:
    VCraftMCPE
    if I used to hereAuth is there a way to move it to MySQL?
     
  5. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
    applqpak and HBIDamian like this.
  6. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
    Yes, I already told you that the /import command can import SimpleAuth databases.
     
    applqpak likes this.
  7. VCraft

    VCraft Witch

    Messages:
    60
    GitHub:
    VCraftMCPE
    Okay
     
  8. Awzaw

    Awzaw Zombie Pigman Poggit Admin

    Messages:
    726
    GitHub:
    awzaw
    If you want to convert SimpleAuth yaml to MySQL (and then to HereAuth.... ), this should do the trick - you'll just have to get Spyc and replace the correct paths:



    ps I just dug this out of an old backup, so please test it before you run it on a production system
     
  9. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin

    Messages:
    1,968
    GitHub:
    sof3
    The MySQL extension is already deprecated by mysqli now ;)
     
  10. Awzaw

    Awzaw Zombie Pigman Poggit Admin

    Messages:
    726
    GitHub:
    awzaw
    Indeed, and I'm not even sure Spyc still exists! Might help someone get it done though, and it's worth doing if you've got a lot of registered players
     
  11. VCraft

    VCraft Witch

    Messages:
    60
    GitHub:
    VCraftMCPE
    Ah idk, I just need to move it to run another server.
     
  12. Awzaw

    Awzaw Zombie Pigman Poggit Admin

    Messages:
    726
    GitHub:
    awzaw
    If you mean the original is also MySQL, just dump the database and import it on the new server. If the data is in yaml files, you can use the script above to import the data into a MySQL database, then dump and migrate.
     
  13. Junkdude

    Junkdude Zombie

    Messages:
    346
    GitHub:
    JunkDaCoder
  14. VCraft

    VCraft Witch

    Messages:
    60
    GitHub:
    VCraftMCPE
    Anyway i moved it thanks for your help guys.
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.