MySQL no longer works Topic is solved

[SocketPup]

It seems I can no longer access my Joomla project, because MySQL no longer works for me in Xampp.
What do I do to mend this? I tried changing port in the config file, but that didn't do anything.
I don't want to lose my data, so I thought I'd ask the pros on here before I try anything else.

Also, is it possible to switch over from Xampp to Wamp on an existing Joomla project? If so, is it a risky process that should be avoided, or is the process fairly safe & straightforward?

[gws]

To move from xamp to wamp is easy with akeeba. Can you access the db from phpmyadmin?

[SocketPup]

To move from xamp to wamp is easy with akeeba. Can you access the db from phpmyadmin?

Negative, as my original post said, MySQL has for some reason stopped working in Xampp. So I need to have that part mended before I can access phpAdmin. =/
Any suggestions as how to make MySQL work again?

[gws]

I haven't used xamp for years but there must be logs in xamp?

[SocketPup]

I haven't used xamp for years but there must be logs in xamp?

Yes, here's the log from after I just tried starting the MySQL:

2024-04-09 13:11:42 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 12900
2024-04-09 13:11:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-09 13:11:42 0 [Note] InnoDB: Uses event mutexes
2024-04-09 13:11:42 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-09 13:11:42 0 [Note] InnoDB: Number of pools: 1
2024-04-09 13:11:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-09 13:11:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-09 13:11:42 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-09 13:11:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-09 13:11:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-09 13:11:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-09 13:11:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-09 13:11:42 0 [Note] InnoDB: Waiting for purge to start
2024-04-09 13:11:42 0 [Note] InnoDB: 10.4.32 started; log sequence number 39756759; transaction id 41006
2024-04-09 13:11:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-09 13:11:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-09 13:11:42 0 [Note] InnoDB: Buffer pool(s) load completed at 240409 13:11:42
2024-04-09 13:11:42 0 [Note] Server socket created on IP: '::'.

[gws]

That seems to show that mysql started OK?

[SocketPup]

Looks like I was able to resolve it by doing the following (in case someone else with similar problem stumbles upon this thread in the future):


Rename the folder mysql/data to mysql/data_old (you can use any name)
Create a new folder mysql/data
Copy the content that resides in mysql/backup to the new mysql/data folder
Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)

Finally:

copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
Start MySQL from XAMPP control panel

[SocketPup]

To move from xamp to wamp is easy with akeeba. Can you access the db from phpmyadmin?

Ok, I got Xampp to work again. So how do I move over my Joomla project from Xampp to Wamp?
I guess step 1 is to download and install Wamp from this site? https://www.wampserver.com/en/

I guess I should also do some database dump from phpadmin in Xampp?

[gws]

Use Akeeba its painless and free. https://extensions.joomla.org/extension/akeeba-backup/
Best site for wampserver is ; https://wampserver.aviatechno.net/?lang=en

[SocketPup]

Use Akeeba its painless and free. https://extensions.joomla.org/extension/akeeba-backup/
Best site for wampserver is ; https://wampserver.aviatechno.net/?lang=en

It seems I can't install Wamp, I get the following error:



Do I need to download each of these packages/programs, or just a few? I guess I'll find them at the link shown in the message.

[gws]

Thats because you didn't read the docs.... It tells you to make sure the C++ libraries are installed first.

[toivo]

You can download the executable VisualCppRedist_AIO_x86_x64.exe from https://github.com/abbodi1406/vcredist/releases. This All-In-One file installs all the Visual C++ Redistributable Packages in one go.

[SocketPup]

Thats because you didn't read the docs.... It tells you to make sure the C++ libraries are installed first.

Ok, so I installed all the libraries needed and Wampserver64 seems to have been installed successfully.
However, when I start it, it shows a screen: "All servers running," then it closes.

What do I do next? In Xampp, I got this gui where I could start/stop servers & databases, and access phpMyAdmin. Doesn't Wamp have something similar?

[gws]

Ok, so I installed all the libraries needed and Wampserver64 seems to have been installed successfully.
However, when I start it, it shows a screen: "All servers running," then it closes.

Thats normal ,you should have an icon in your task bar for Wamp?

[SocketPup]

Ok, so I installed all the libraries needed and Wampserver64 seems to have been installed successfully.
However, when I start it, it shows a screen: "All servers running," then it closes.

Thats normal ,you should have an icon in your task bar for Wamp?

Ah, yes, I see it. When I click it there is a menu with localhost, phpMyAdmin, etc. Very neat.

So in order to migrate my Joomla project from Xampp to Wamp, I need to install the Akeeba extension in my current Xampp project, right? What's the step after that?

[gws]

Read the docs at Akeeba so you are sure,it is however very easy. Once installed Akeeba will produce a .jpa file that is a complete copy of your site, files and DB. Then copy the .jpa file to the root of your new site,Akeeba supplies a file called kickstart.php place that in the same folder as your jpa file. In your browser go to localhost/joomla site/kickstart.php and then follow the installation instructions.

[AMurray]

Summary instructions using Akeeba can be found here: https://docs.joomla.org/Copying_a_Joomla_website.

[Webdongle]

Bottom of https://wampserver.aviatechno.net/
Take your pick 32bit or 32bit and 64bit (windows 64 bit requires 32bit and 64bit)

wamp 02.JPG

[SocketPup]

Read the docs at Akeeba so you are sure,it is however very easy. Once installed Akeeba will produce a .jpa file that is a complete copy of your site, files and DB. Then copy the .jpa file to the root of your new site,Akeeba supplies a file called kickstart.php place that in the same folder as your jpa file. In your browser go to localhost/joomla site/kickstart.php and then follow the installation instructions.

Thanks, it seems the extension was installed successfully, and the wizard configured Akeeba without issues.
However, when I click "backup now" I see the following warning:

Akeeba Backup may not work as expected

Akeeba Backup detected the following potential problems:

Default output directory in use

Can I ignore this, or should I do something about it?

[gws]

Ignore it.

[SocketPup]

Ignore it.

Ok, great. I was able to create a .jpa that I have now downloaded. If I understand correctly, next step is to move that file into the root of WAMP, then start Wamp?

A few questions:

1. in Xampp, the root folder is htdocs. Root of Wamp is "www" correct?
2. Once in the root, do I just add the .jpa file there, or should I create a folder and store the file in there? If so, do I need to name that folder exactly the same as the folder name of my original project?
3. I extracted the kickstart.php from kickstart-core-8.0.4. This is the file I need to put in the same folder as my .jpa file, right?

[gws]

create a folder in www ie joomla and install in that. You can then create as many folders in www as you want and each one can have a different website in it.

[SocketPup]

create a folder in www ie joomla and install in that. You can then create as many folders in www as you want and each one can have a different website in it.

Got it. I am following this video guide to learn the steps: https://www.akeeba.com/videos/1212-akee ... erver.html However, at 03:37 I am expected to type in the db info. Am I expected to type in a new username & pw, or the same as the old one? If the latter, can I access that information from phpMyAdmin or the like from my old project (as I only saved un & pw for my Joomla Super User)?

[Webdongle]

Ignore it.

... If I understand correctly, next step is to move that file into the root of WAMP, then start Wamp?

...

NO you will break wamp

Create a folder in wamps \www folder e.g. \www\joomlatest01

[SocketPup]

Ignore it.

... If I understand correctly, next step is to move that file into the root of WAMP, then start Wamp?

...

NO you will break wamp

Create a folder in wamps \www folder e.g. \www\joomlatest01

Thanks.

[SocketPup]

Seems all went well migrating from Xampp to Wamp. Thanks all!