Wrong database type Topic is solved
Moderator: General Support Moderators
Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
-
- Joomla! Enthusiast
- Posts: 244
- Joined: Mon Aug 26, 2019 10:58 am
- Location: Zagreb, Croatia
- Contact:
Wrong database type
OMG how can I convert MySQL 5.7.36 to MariaDB 10.6.5 and exchange it in Joomla4 I made?
-
- Joomla! Champion
- Posts: 5950
- Joined: Tue Aug 23, 2005 1:56 pm
- Location: South coast, UK
- Contact:
Re: Wrong database type
Export (via phpmyadmin) the mysql DB to your desktop ,create the new DB in maria-db and import the exported sql into the maria DB.
https://gadsolutions.biz Electrical services
https://electrical-testing-safety.co.uk Testing services
https://electrical-testing-safety.co.uk Testing services
-
- Joomla! Enthusiast
- Posts: 244
- Joined: Mon Aug 26, 2019 10:58 am
- Location: Zagreb, Croatia
- Contact:
Re: Wrong database type
I can't import, I get this Error.
And how will I exchange it in Joomla?
You do not have the required permissions to view the files attached to this post.
-
- Joomla! Champion
- Posts: 5950
- Joined: Tue Aug 23, 2005 1:56 pm
- Location: South coast, UK
- Contact:
Re: Wrong database type
If your on a shared hosting ask the host to check the error messages.
https://gadsolutions.biz Electrical services
https://electrical-testing-safety.co.uk Testing services
https://electrical-testing-safety.co.uk Testing services
-
- Joomla! Enthusiast
- Posts: 244
- Joined: Mon Aug 26, 2019 10:58 am
- Location: Zagreb, Croatia
- Contact:
-
- Joomla! Champion
- Posts: 5950
- Joined: Tue Aug 23, 2005 1:56 pm
- Location: South coast, UK
- Contact:
Re: Wrong database type
check the maria db settings in the wamp menu.
https://gadsolutions.biz Electrical services
https://electrical-testing-safety.co.uk Testing services
https://electrical-testing-safety.co.uk Testing services
-
- Joomla! Enthusiast
- Posts: 244
- Joined: Mon Aug 26, 2019 10:58 am
- Location: Zagreb, Croatia
- Contact:
Re: Wrong database type
lol ok never mind, I can make new web from begining and everything copy, but now I see I can't make web with MariaDB because only options are MySQLi and MySQLi(PDO). So can't make Joomla 4 with MariaDB?
-
- Joomla! Champion
- Posts: 5950
- Joined: Tue Aug 23, 2005 1:56 pm
- Location: South coast, UK
- Contact:
Re: Wrong database type
maria db works with MySqli and MySqli pdo.
Maria DB is a fork of MySql by the original developers,for the most part they are similar.
Maria DB is a fork of MySql by the original developers,for the most part they are similar.
https://gadsolutions.biz Electrical services
https://electrical-testing-safety.co.uk Testing services
https://electrical-testing-safety.co.uk Testing services
- toivo
- Joomla! Master
- Posts: 17439
- Joined: Thu Feb 15, 2007 5:48 am
- Location: Sydney, Australia
Re: Wrong database type
You can use MariaDB with the same drivers. If you run both MariaDB and MySQL servers in Wampserver and MySQL uses 3306, use 3307 as the port for MariaDB.
Toivo Talikka, Global Moderator
-
- Joomla! Enthusiast
- Posts: 244
- Joined: Mon Aug 26, 2019 10:58 am
- Location: Zagreb, Croatia
- Contact:
Re: Wrong database type
it is like that, but in Joomla global config I can choose only MySQLi and MySQLi(PDO). I'm sorry if I ask something stupid.
You do not have the required permissions to view the files attached to this post.
- toivo
- Joomla! Master
- Posts: 17439
- Joined: Thu Feb 15, 2007 5:48 am
- Location: Sydney, Australia
Re: Wrong database type
Did you try those drivers with port 3307? Use the database host localhost:3307
Toivo Talikka, Global Moderator
-
- Joomla! Enthusiast
- Posts: 244
- Joined: Mon Aug 26, 2019 10:58 am
- Location: Zagreb, Croatia
- Contact:
Re: Wrong database type
now I put this in new instalation but got same error
On live server is MariaDB 10.3.36 and I made web in WAMP with MySQL 5.7.36, but maybe must make empty base there before installation from Kickstart. It is not mine, I'll know later does it work.
You do not have the required permissions to view the files attached to this post.
-
- Joomla! Enthusiast
- Posts: 119
- Joined: Thu Mar 20, 2014 1:29 pm
Re: Wrong database type
Which version of wamp are you using because maybe
is more convenient to install a new version
or expand yours with extras
https://sourceforge.net/projects/wampse ... .0/Addons/
is more convenient to install a new version
or expand yours with extras
https://sourceforge.net/projects/wampse ... .0/Addons/
You do not have the required permissions to view the files attached to this post.
-
- Joomla! Apprentice
- Posts: 11
- Joined: Wed May 12, 2021 10:44 am
Re: Wrong database type
You can use mysqldump to export your database and then import into mariadb
-
- Joomla! Enthusiast
- Posts: 244
- Joined: Mon Aug 26, 2019 10:58 am
- Location: Zagreb, Croatia
- Contact:
Re: Wrong database type
Ok, I wasn't on forum, and during that time web is upload and I see that server is not swith on MySQL, but it seems he converted my Joomla to MariaDB lol. Now I have only hmepage, and any link in menu doesn't work. I use helix with SP age builder - free version, and I can't open any sp-page, can't open Joomla articles, can't open contact, links don't work. Error is:
Would someone help me please to make them to work?Not Found
The requested URL was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
You do not have the required permissions to view the files attached to this post.
-
- Joomla! Enthusiast
- Posts: 244
- Joined: Mon Aug 26, 2019 10:58 am
- Location: Zagreb, Croatia
- Contact:
Re: Wrong database type
omg I turned off SEO redirection and now website works