Import database from old server

RichardT

When i restart the server after db change web page will load but i cant login with admin account

KevinTheJedi

So it's a customized version? If so you will need to reach out to the maintainer of the custom build for further assistance. We can only support core osTicket and core osTicket plugins here.

Cheers.

RichardT

KevinTheJedi
not sure what you mean by customized version its the latest release 1.17

KevinTheJedi

RichardT

We don’t add anything to the name so if you have "osTicket-u" that’s not a core version. Where did you download this from?

Cheers.

RichardT

its just translated in slovak language

KevinTheJedi

RichardT

Ah, post a screenshot next time. Posting text doesn't convey the whole picture.

So for the login issue, what exactly do you mean? Do you have any authentication backends configured?

Cheers.

RichardT

im not sure probably something wrong with the database when importing i get error ERROR 1064 (42000) at line 5726: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<div class="alert alert-danger" role="alert"><h1>Error</h1><p><strong>SQL que...' at line
Should i edit the database manually should it work to import database from 5 mysql to 10? even after error i can see the database have 70% of size the file.

merovatis

You could check your import script at line 5726, fix it and restart process with clean db?

RichardT

merovatis
not sure what you mean i just create blank database and the import it
MariaDB [(none)]> CREATE DATABASE Ticket

[root@localhost etc]# mysql -u root -p Ticket < bzx6v1zi.sql
Enter password:
ERROR 1064 (42000) at line 5708: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<div class="alert alert-danger" role="alert"><h1>Error</h1><p><strong>SQL que...' at line 1
[root@localhost etc]#

KevinTheJedi

RichardT

I would use source instead of importing like that. You just login to MySQL, “use” the database, and run the following:

source /path/to/file.sql;

Cheers.

RichardT

KevinTheJedi
It ended with same error ive exported it web interface phpmyadmin. Tried manualy just move the tables with program dbeaver but there were also many errors dont know what to do.

KevinTheJedi

RichardT

Never use phpMyAdmin. It's ass. Always use MySQL Dump command via CLI. This is the best option.

Cheers.

RichardT

KevinTheJedi thanks didnt know that i exported it another way and it worked fine thanks for help