Import 5gb sql file into MYSQL database

[vadim]

I have tried so many times, everything upgraded on source server, did dumps for many times and after import I don't see any data on Cloudron installation. Just blank traccar with demo login.

[BrutalBirdie]

@BrutalBirdie said in Import 5gb sql file into MYSQL database:

You can always directly upload it to the root server and move it into the /app/data/ folder.
Just rsync the file to the root server and move it to /home/yellowtent/appdata/{ID}/data/

@vadim this is one of the most save ways to get the file to the server.
Once on the root system you can copy it over and over for trying out different solutions so you don't have to wait for the upload over and over again.

[vadim]

@BrutalBirdie I have sql files in /app/data and use this way. But every import is blank. No way to get data from source service.

I have Traccar installed for 4 years since very old version. DB works perfect with new version. Could be there a problem with "old" db trying to import to a new installation?

[girish]

@vadim so the DB is importing but you have to make sure that you import the database into the right version of traccar. Which version of traccar were you using?

Also, after import, have you tried inspecting the tables? Make sure you were not using any table prefixes etc.

[vadim]

@girish I have version 5.12. But when version is upgraded database and config left the same without changes.
Now I got this situation during import and app not responding after!

[vadim]

Actually I finally got DB, but I also got another problem
No one user, also my old admin account, not able to login and it is not possible to recover and change password.

[girish]

@vadim when you installed traccar, did you install it with Leave user management to the app ? Otherwise, it will use LDAP by default. This flag can only be set at install time. So, start with a fresh installation and select Leave user management to the app at install time.

[vadim]

After a fresh installation with the option "Leave user management to the app" (the same option was used previously), none of the existing users are able to log in. Additionally, it's impossible to change or recover their passwords. I cleared the old database and proceeded with the import. However, after doing so, the system user admin@cloudron.local, who shouldn't be present, remained in the system after the import.

[girish]

@vadim said in Import 5gb sql file into MYSQL database:

However, after doing so, the system user admin@cloudron.local, who shouldn't be present, remained in the system after the import.

I guess you found this out by checking the users table in traccar ? In Cloudron package, the table name is tc_users . What is the table name of users in your mysql dump?

[girish]

This was sorted out in support.