Can you give me some kind of guide for import old version mysql db to the latest instance?

Mysqldump

Yes i know. I mean are there any problems with old db versions after import?

I think if you instead use mysql workbench, it should take care of doing it

There is the migration guide on official docs site

Thanx

Can some one help with this, I am trying to initialize mysql 8.0.23 it’s a fresh installation and this below error is prompting

Failed to find valid data directory.
Data Directory initialization failed.
Aborting.

All permissions are in place and am using mysql user to initialize the server.

Check datadir variable in my.cnf ? Excuse my ignorance but I have never ever had to initialise data directory when installing from binary packages.

Defined directory should have mysql owner and group

It has mysql as owner only
I should mention here that this is not the first time I am installing I am well aware of the process. But even to me this error is new the keyword here being ‘valid’

That is just changing path to dir. Right? Nothing like –initialize or so like they say?

This is arguable… actually the user and group can be anything….

Actually yes. It should match the name and group defined in the same config file or mysql if nothing defined

Don’t do administrative tasks with php , this is just never should be done.

Use mysql utility.

https://github.com/Piterden/crosswords-module/blob/master/src/CrosswordsModuleSeeder.php

You (or your user) are anyway should fill some data before start install. Have you already done the installer of other not DB stuff?

But you sad you have already sold your projects. How people installed them?

Hello guys, I am new Lerner and unable to do rpm installation mysql on redhat 8 , I downloaded the rpm files for mysql version 8.0.23 .. could you please share the sequence and steps for installation mysql on Linux. Thanks in advance

https://www.tecmint.com/install-latest-mysql-on-rhel-centos-and-fedora/

Ok, thanks let me try . I was trying with rpm -ivh commands and getting errors

You should try to google “mysql redhat install”

https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/6/html/managing_confined_services/chap-managing_confined_services-mysql

I got multiple different different docs hence totally got confused from where to start

You should learn to feel it

Yes, you are absolutely right 👍 , really appreciate your help on this

Oh, NP! )

Thanks , I have successfully done installation

Can anyone share the document to repair corrupt dbs in mysql if possible?

For innodb engines restart the server with innodb_force_recovery and values can be 0 to 6
For Myisam use repair table

Hey guys i am beginner please is there anyone who can tell me how can i see table that i created from this program 🙏🙏 please help me

select * from makgato

So it means i should cancel this program before ?

Well that program aka… is code that basically creates the table … simple is that. Table is gonna be empty since no data has been inseted… Select * means: select all columns…. from name of the table…
And not sure what you mean by cancel… you can leave that code, save it or whatever… but you execute new commad…

Ok thanks

It gives me errors 😭😭