Want to migrate mairlist db to new pc

[Alanqfm]

Transfer to new PC

Install mAirList demo on the new computer. Open mAirListConfig on the old computer, go to Advanced -> Data Folders, and open the root data folder in Windows Explorer. Repeat step 2 on the new computer. Copy all files and folders, except license.lic, from the old to the new data folder. Uninstall mAirList from the old computer. Use the contact form on the website to request a reset of your license (enter your serial number to speed up the process). When you receive the message…

I am using Mairlist 6.0 for our FM radio. I want to migrate DB software to a new PC. all the things like SQL , demo installation all done. but I am not getting the Folder structure that I am using now is not getting in the new PC. I did the above mentioned steps. but that time the IP Address of the old PC is showing in the new PC Database login area. if I change it to the new PC’s IP Address, the connection will be loss and the folder structure will be gone

[Stefan_Hillen]

One database is

mairlistdb

the other login for

mairlist9

Is this intended?

[Alanqfm]

Yes, because if i give same db name, the old pc database is showing. But if I disconnect that pc from the network, the connection will be lost. Can i get the folder structure to the new pc ? I dont know the sql things. I just did it myself after reading the manual in mairlist website. Can you guide me through the correct steps from the beginning?

As the FM is playing Onair 24x7 I can’t disconnect the db already running.

[Liam]

@Alanqfm

Yes, because if i give same db name, the old pc database is showing. But if I disconnect that pc from the network, the connection will be lost.

Try entering the same database name with the new PC IP address. It is important that you have transferred the database from the old PC to the new one. Then the whole thing should work.

There is no point in leaving the old PC on just for PostgreSQL.

[Alanqfm]

I tried to take the backup of database from sql. But it failed when restore in new pc.

[Stefan_Hillen]

First things first:

@Alanqfm

I am using Mairlist 6.0

Really 6.0 and not one of the latest versions? Why? Latest was 6.3.24 before v7 came out.

Now to the rescue:

The thread you quoted above is more than eleven (11!) years old and was recent for v4.

Please use this instruction:

Setting Up mAirListDB With MySQL On a NAS

Ok, so you want to migrate your existing (local mode) mAirListDB to a MySQL backend, right? This is what “Clone database” in the DB App (Database → Export → Clone Database) is made for. Works for any SQL type (networked or local mode) for source and target. These are the steps to perform: Create user and empty SQL database in your MySQL server. Do not add the connection to the mAirList configuration at this time! In particular, do not perform the initial setup (create tables) in the config!…

After you successfully cloned the dB you are fully independent from the dB at the other PC.

@Alanqfm

Can i get the folder structure to the new pc

This is just the structure of the VIRTUAL folders, set up in the database. So any time you copy/clone the database it will show these folders.

[Stefan_Hillen]

For the clean installation of the PostgreSQL please take a look in the new FAQ:

Setting up PostgreSQL for mAirList Professional

The database (mAirListDB) in mAirList Professional can use We support several SQL types, one of which is PostgreSQL, which is free and open source, and also the recommended backend for mAirList. PostgreSQL is available for several operating systems, including Windows and also Linux. This tutorial focuses on Windows using the graphical user interface provided by PostgreSQL (pgAdmin). Experienced Linux admins will prefer to use command line tools instead. We will briefly cover this at the end of…

[Alanqfm]

I’ve cloned the database. But when i try to import it to the new pc there is only showing some specific .mldb files. The cloned file cannot open. I will look into the new FAQ and will back to you.
Thank you for the support.

[Stefan_Hillen]

@Alanqfm

But when i try to import it to the new pc

Wait, what?

You don’t need to import any dB files if you followed the instructions here:

@Stefan_Hillen

The thread you quoted above is more than eleven (11!) years old and was recent for v4.

Please use this instruction:

Ok, so you want to migrate your existing (local mode) mAirListDB to a MySQL backend, right? This is what “Clone database” in the DB App (Database → Export → Clone Database) is made for. Works for any SQL type (networked or local mode) for source and target. These are the steps to perform: Create user and empty SQL database in your MySQL server. Do not add the connection to the mAirList configuration at this time! In particular, do not perform the initial setup (create tables) in the config!…

Then you need to copy all your music files / elements in the exact same folder hierarchy similar to the old PC.

Please follow the instructions linked above step by step - it’s no magic

And I really suggest to update to the latest v6.3.24. Or are there any reasons you can’t?

[Alanqfm]

2. Open the DB app (of the existing local mode app) and go to Database → Export → Clone database. Select MySQL as the target type, and enter IP/user/password/database as required. Cloning will copy the tables row by row, so it might take a long time. You can choose to transfer only part of the playlist history to speed up the process.

Here, which IP/User/password/database I should have to give? the new PC IP or Old one? Can u type here an EXAMPLE??? Please??

[Alanqfm]

I tried the database backup steps and nownshoung this error.

Is there any solution? Or Can i give you my pc in remote, so that you can help me.

[Alanqfm]

After tried a lot now i am in this position.

[Liam]

PostgreSQL 13+: "[FireDAC][Phys][PG][libpq] authentication method 10 not supported." error

Here is infomation for all users that intend to use mAirList with version 13 and later of the PostgreSQL server: PostgreSQL 13 (and later) uses the new scram-sha-256 password encryption by default, something that is not supported by the libpq.dll client library shipped with mAirList by the time of this writing (v6.3.6). Thus, you will see the following error: [FireDAC][Phys][PG][libpq] authentication method 10 not supported. We are going to ship an updated libpq.dll in the near future. Until…

[Alanqfm]

I did these steps. And I can connect thr db to thr playout software from the same pc that i installed the db app. But my onair pc is in another studio and I can’t login there. When i try to connect the db there it shows the same error. Please look at this image carefully.

When i trying to add the db on a second pc with the same credentials it shows error

[Torben]

For mAirList 6 and PostgreSQL 12+,. you have to install the newer libpq.dll and support libraries from here: https://download.mairlist.com/other/libpq10.zip

Just copy the contents into the mAirList program directory, replacing the existing files.

mAirList 7 already ships the newer versions.

[Alanqfm]

Hi, I have already downloaded and copied these files. The only problem now having is , I cant connect the db to another pc having the mairlist professional studio software.

[Alanqfm]

Any thing to do here???

[Stefan_Hillen]

@Alanqfm

I cant connect the db to another pc having the mairlist professional studio software.

Add the second line in the pg_hba-file with the IP of the remote PC like in the example.

# IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256
host    all             all             xxx.xx.xx.xx/32        scram-sha-256

[Alanqfm]

Thank you @Stefan_Hillen ! It has connected. But I tried to login the database to the mairlist professional studio, all went good. Logged in. But it showing “ the files can’t open”. If this can solved I can connect the db to the onair. Hope you will guide me.

[Liam]

@Alanqfm

But it showing “ the files can’t open”

Do you really have all the music/jingle files in the folder that is in your database?

Open database -> Administration -> Configuration... -> Storage locations