Authmereloaded: Taking a backup

[DarkOakHD]

Greetings,

I know thats not a error or a bug but i need your help...

So how do i take a backup of a Database that is on the mysql (phpmyadmin) ?

Do i type /authme converter mysqltosqlite ?

If i do that, will the mysql continue to work as it is or it will change in the config from mysql to sql ?

Thanks, hope you can help me :100:

[sgdc3]

mysqldump is the best way in my opinion ;)

[sgdc3]

Backup: mysqldump –u [username] -p[password] [database name] > outputFile.sql
Restore: mysql -u [username] -p[password] < sourceFile.sql (remember to delete the db first)

[sgdc3]

in -p[password] the absence of spaces is intentional

[sgdc3]

@ljacqu what would you prefer to do?

[DarkOakHD]

So, do i type this in the console or thru minecraft ?
Or in the phpmyadmin ?

[sgdc3]

system console ;)

[sgdc3]

also phpmyadmin, look for the export button ;)

[DarkOakHD]

The authme (or the HUB) is on a Shared hosting...

So export button works?

[DarkOakHD]

So thats it ?
http://prntscr.com/ezt02a

How do i now import it to authme when i want ?

(want to change host's so asking how to do that)

/authme converter sqlitetosql ??

[ljacqu]

I thought we had a command for it, turns out we don't

[ljacqu]

pphMyAdmin export function would be my suggestion for now :)

[DarkOakHD]

But i have now a .sql file
how do i convert it to .db and from .db to mysql (changing hosts)

[ljacqu]

There's an Import tab in phpMyAdmin. Otherwise I think you can just run the sql code otherwise :)

[DarkOakHD]

Let me try that

[DarkOakHD]

The import doesent work...
No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

[ljacqu]

In phpMyAdmin open the database you want to export, click on the Export tab and just export as SQL. This will generate a SQL file—download it, open the phpMyAdmin page of the server you want to import to, this time select the Import tab and upload that SQL file again.
If you have a large number of entries you can select the "Custom" checkbox while exporting and under "Compression" you can select "zipped" or "gzipped." The import procedure remains the same.

[ljacqu]

Failing that, you can convert your MySQL to SQLite and download the resulting auths.db file and copy it over to the other server. Start AuthMe and then you can convert back from SQLite to MySQL.
If I re-read this again I suspect you tried to import the SQLite file into phpMyAdmin.

[sgdc3]

Just convert from mysql to sqlite, download the db file and then convert it again to mysql. @Darko266