MySQL Forums - Other Migration

Update from mysql 8.0.36 to mysql 8.0.42 (1 reply)

Mircea-Voicu Voicu — Wed, 24 Sep 2025 01:22:29 +0000

Hello,

I have an MySQL InnoDB ReplicaSet Cluster consisting of 4 members.
The server version on all members is mysql-community-server-8.0.36.
All nodes are running AlmaLinux 9.
I want to update from mysql-community-server-8.0.36 to mysql-community-server-8.0.42 via dnf package manager.

Can I apply this update without any issues on all nodes?
Will the cluster be affected in any way?
Does it matter on which node I apply these update first?

Thank you.

Need Assistance migrating MySQL Server 5.6 to 8 (no replies)

Vito Cavallo — Sat, 03 Jun 2023 02:32:04 +0000

Hello,
A CentOS 6 server I inherited was running MySQL Server 5.6.10 and the system drive died before I could migrate to MySQL 8. I have a tape backup of the mysql data folder.
I read I need to get to 5.7 before I can migrate to 8, is this correct?

I installed CentOS 7 MySQL 5.6.51 from the RPM package an updated via the yum repo file. I am guessing I need to have a working mysql in current version before I migrate higher.
I verified the path in my.conf file was pointing to the correct folder. mysqld does not start, I am getting many failures. I am thinking the 5.6.10 is a bit different than 5.6.51 and I probably need to start with the original version.

My main goal to be running Rocky Linux 8 or 9 and mysql 8.x.
Can anyone offer some high level tasks to get me to 5.7 and 8?
Am I on the correct path going up with the version numbers?
Shall I start with a new blank database and import the old databases?

Thank you.

Need Assistance migrating MySQL Server 5.6 to 8 (no replies)

Vito Cavallo — Sat, 03 Jun 2023 02:27:49 +0000

Hello,
My CentOS 6 server was running MySQL Server 5.6.10 and the system drive died before I could migrate to MySQL 8. I have a tape backup of the mysql data folder.
I read I need to get to 5.7 before I can migrate to 8, is this correct?

I installed CentOS 7 MySQL 5.6.51 from the RPM package an updated via the yum repo file. I am guessing I need to have a working mysql in current version before I migrate higher.
I verified the path in my.conf file was pointing to the correct folder. mysqld does not start, I am getting many failures. I am thinking the 5.6.10 is a bit different than 5.6.51.
Can anyone offer some high level tasks to get me to 5.7 and 8?
Am I on the correct path going up with the version numbers?
Shall I start with a new blank database and import the old databases?

Thank you.

how to convert sql trigger to mysql (5 replies)

Omer Ahmed — Sat, 16 Jul 2022 13:23:26 +0000

Dear all
i shifted from sql server to mysql . i wrote one trigger in sql server but now i m facing issues while converting it to mysql.
can anyone please help me

below is the trigger

USE [medicav1]
GO
/****** Object: Trigger [dbo].[COI_tri] Script Date: 7/15/2022 1:27:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[COI_tri] ON [dbo].[COA]
FOR INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON
IF NOT EXISTS ( SELECT * FROM inserted)
RETURN
UPDATE dbo.COA
SET accounttype = CASE WHEN COA.openingbalance > 0 THEN 'DR'
ELSE 'CR' END
FROM dbo.COA COA
WHERE EXISTS ( SELECT *
FROM inserted i
WHERE i.coaid = COA.coaid
)
END

Sql Server 2012 to 2016 (1 reply)

Dip Liko — Thu, 23 Sep 2021 15:41:23 +0000

I m trying to migrate Database from SQl server 2012 to 2016 .but its showing error ..

How to install MySQL server on pen drive (1 reply)

Yogesh Survase — Sat, 27 Mar 2021 05:56:50 +0000

I have to make a c# plug and play desktop application. That means the application and database reside in pen drive. When I connect pendrive to pc. The application will start without installation and Database is stored in pendrive

How many connections are possible with Aiven for MySQL? (1 reply)

Carter Planey — Tue, 24 Nov 2020 17:23:58 +0000

Hello!

We decided to load our database systems onto a cloud because of the huge amount of work involved.
This will be hosted by the DBaaS provider Aiven for MySQL. We practically brought the cloud with us ourselves because we already had an account.
The advantage of this: no hardware costs, the provider takes care of monitoring and backups.
Regarding MySQL, I have a question: How many connections are possible with MySQL when we use Aiven? Does anyone know more?

Thanks in advance

Add New User with Specific Expire Date (2 replies)

Gabriel Turqos — Thu, 11 Jun 2020 19:06:08 +0000

I want to add a user account to my linuxbox. But this user will have specific expire time which will be specified at the useradd definition.

Integration with arabic text from MS SQL Server to MySQL (no replies)

David AG — Sun, 07 Jun 2020 22:36:57 +0000

Hello,

I have a project which requires integration between 2 databases. One is hosted in server1 and using MSSQL Server, and one is hosted in Server2 and using MySQL.

I need to update the table of Customer in MySQL database on frequent basis (twice per day) from the “Customers” table in the MSSQL Server; noting that the table in MSSQL Server includes Arabic text.

How does I achieve this!

Please help!

Check Java version from Command Line (2 replies)

Gabriel Turqos — Mon, 01 Jun 2020 11:00:10 +0000

I have a Java installation and I have only access via bash. How can I check the Java version from command line.

List Only Usernames (1 reply)

Gabriel Turqos — Tue, 26 May 2020 18:58:05 +0000

I want to list only users names in a Linux system byusing the /etc/passwd file.

SELECT, COUNT and Inner Join (2 replies)

Geir Anthonsen — Sat, 16 Nov 2019 22:30:46 +0000

I am not to familiar with databases, because I work with wifi networks.

I have imported a text file with all the issues on the network into a SQLite database.

There are 2 tables:

______________________________________________________________________

"Issues" with a "ap_mac_adress" field

and

"AP_names" with a "ap_mac_adress" and a "ap_name" field.

______________________________________________________________________

I try to run a sql query that will count all unique ap_mac_adress in Issues.

This does the job:

SELECT DISTINCT ap_mac_address AS [Ap MAC Adresse], COUNT(ap_mac_address) AS Antall
FROM issues
GROUP BY ap_mac_address
ORDER BY Antall DESC

Result:
AP MAC Adresse Antall
xx:xx:xx:xx:xx:b2 1254
xx:xx:xx:xx:xx:f17 1021
xx:xx:xx:xx:xx:g4 723

But - I would like to have the name of the ap points, not their adress.

And when I do this, i get an error:

SELECT AP_Names, DISTINCT ap_mac_adress AS [Ap MAC Adresse], COUNT(ap_mac_adress) AS Antall
FROM issues
INNER JOIN aksesspunkter ON aksesspunkter.ap_mac_address = issues.ap_mac_adress
GROUP BY ap_mac_adress
ORDER BY Antall DESC

I think it has to do with the AP_Names in the select part, and GROUP by ap_mac_adress.

Can someone please guide me in the right direction??

PVS-Studio Testing on SQLite Code and Related Issues (1 reply)

Andrey Karpov — Mon, 19 Aug 2019 14:41:34 +0000

Hello. I am one of the PVS-Studio analyzer developers. We are currently testing some of our latest diagnostics on various projects, including the SQLite code. Some new diagnostics issue warnings, but we aren't sure that these are errors. First of all, SQLite is a small, high-quality project. And secondly, the code is sometimes very complex and confusing for the analyzer (and a third-party person as well ;). That's why I don't want to jump to conclusions. It's interesting to know the opinion of SQLite developers.

I'll describe two cases below. Please, tell me, in which case it's a false positive and which one is relevant (contains an error).

Fragment N1. PVS-Studio warning: V1040 Possible typo in the spelling of a pre-defined macro name. The '__minux' macro is similar to '__linux'. shell.c 242

Code:

#if !defined(_WIN32) && !defined(WIN32) && !defined(__minux)

What's this magic "__minux"? May be authors wanted to write "__linux__"? Or it is correct and it's a special feature, isn't it?

Fragment N2. PVS-Studio warning: V1044 The diagnostic isn't named yet. sqlite3.c 49362

The code (I removed asserts not to distract from the main point)

static void pcache1EnforceMaxPage(PCache1 *pCache){
  PGroup *pGroup = pCache->pGroup;
  PgHdr1 *p;
  while( pGroup->nPurgeable>pGroup->nMaxPage
      && (p=pGroup->lru.pLruPrev)->isAnchor==0
  ){
    pcache1PinPage(p);
    pcache1RemoveFromHash(p, 1);
  }
  if( pCache->nPage==0 && pCache->pBulk ){
    sqlite3_free(pCache->pBulk);
    pCache->pBulk = pCache->pFree = 0;
  }
}

The analyzer suspects that there may be an infinity loop. Is that true? Reviewing this code, I tend to think that the analyzer is right, but I'm not sure, because the code is quite complex.

In the loop, only members of the 'PgHdr1' class, which the 'p' pointer points to, can change. The variable pGroup->nPurgeable>pGroup->nMaxPage in the loop cannot change, as there is no access to this variable via the 'p' pointer.

The only thing that can change is 'isAnchor'. But when I look into the called functions, I don't see the 'isAnchor' change anywhere. Is it really an error or do we (I and the analyzer) miss something?

Pointless Whining about Bad Dates (1 reply)

James Cobban — Wed, 09 Jan 2019 05:15:23 +0000

After upgrading MySQL the enhanced validation of DATEs has been causing me problems. Web pages that have been working for years suddenly throw exceptions because the current release of MySQL is picky. The problem is that many of the dates in my database are imprecise. That is I do not *know* the exact date of the event in question. If I only know the year that something happened why does the server whine when I do not supply a month and day? I literally do not have values to put in those portions of the date. Since the only purpose of the instances of DATE in my database was for sorting I decided to bypass the problem by replacing the instances of DATE with an INT field. But:

mysql> alter table Deaths modify column d_calcdate INT(10); ERROR 1292 (22007): Incorrect date value: '1824-00-00' for column 'D_CalcBirth' at row 1

Hunh? My command did not say ANYTHING about D_CalcBirth so why did MySQL waste my time by complaining about something that was completely irrelevant to the action which I requested?

So I fixed that by:

mysql> update Deaths set d_calcdate=makedate(year(d_calcdate),182) where month(d_calcdate) = 0;
Query OK, 3649 rows affected (0.22 sec)
Rows matched: 3649 Changed: 3649 Warnings: 0
mysql> update Deaths set d_calcbirth=makedate(year(d_calcbirth),182) where month(d_calcbirth) = 0;
Query OK, 3687 rows affected (0.21 sec)
Rows matched: 3687 Changed: 3687 Warnings: 0
mysql> alter table Deaths modify column d_calcdate INT(10); ERROR 1292 (22007): Incorrect date value: '0000-00-00' for column 'D_ChangeDate' at row 10150

Again I did not ask the server to look at D_ChangeDate so why is it wasting my time with a pointless complaint about something that is irrelevant to what I did ask the server to do?

So I tried to fix the "incorrect" values in the database by:

mysql> update Deaths set D_ChangeDate=null where D_ChangeDate='0000-00-00';
ERROR 1292 (22007): Incorrect date value: '0000-00-00' for column 'D_ChangeDate' at row 1

I am not asking the server to INSERT an invalid date value into the database so why does it object when I ask it to look for date values THAT ARE ALREADY IN THE DATABASE!

So I got around that by:

mysql> update Deaths set D_ChangeDate=null where Month(D_ChangeDate)=0;
Query OK, 40 rows affected (0.12 sec)
Rows matched: 40 Changed: 40 Warnings: 0

mysql> alter table Deaths modify column d_calcdate INT(10);
Query OK, 27317 rows affected (2.62 sec)
Records: 27317 Duplicates: 0 Warnings: 0

mysql> alter table Deaths modify column d_calcbirth INT(10);
Query OK, 27317 rows affected (2.91 sec)
Records: 27317 Duplicates: 0 Warnings: 0

It is annoying that MySQL complains about date values that are *already* in the database because an earlier release did not validate them. If a value is already in the database, even if the current release would not PUT that value into the record it should not force the programmer to deal with pointless whining.

This pointless unproductive whining by your product encourages me to migrate to MariaDB which does NOT waste me time!

convert date in julian date (2 replies)

Gary Ehrenfeld — Wed, 24 Jul 2019 20:57:30 +0000

I am importing a CSV file that has a date field that has 2018/07/28 04:10:00.

I want to import it into my sqlite3 database as a Julian date.

How would I do that?

Select records by MAX(time) - 90 days (1 reply)

Gary Ehrenfeld — Tue, 25 Dec 2018 11:33:54 +0000

I have a sqlite3 database that has data downloaded from my diabetes meter. I download the data from the meter daily.

I now do a calculation on the database using every record in the database.

What I need to do is get a list from the database that comprises all the records that are from the last date that was appended minus 90 days to the last append record.

example: Select * from meter where time > last append time -90 days

Hope I made sense of what I need to do.

Thanks

MYSQL assessment report for Mysql server upgradation or migration process (no replies)

Venkat K — Mon, 05 Nov 2018 05:58:24 +0000

Hi Team,

Please let us know if there are any tools or scripts available prior to 8.0 versions for assessing MySQL server for upgradations or migrations from one server to another server .

Connecting to MySql remotely using sqlstrconnect (no replies)

Gordon Haas — Mon, 13 Aug 2018 17:42:23 +0000

Have FoxPro VFP 8 connecting to MySql Server "locally" using sqlstringconnect. Using the MySql ODBC 5.3.11 connector. When I try to connect "remotely" to MySql Server using the same sqlstringconnect it fails. The user is "defined" as host "%" in his setup. In the System DSN the ip address of the Server is specied, not localhost. In the sqlstringconnect that same ip address is specified, same user, same password. The FoxPro .exe that is making the connection, locally, is resident on the same system as the MySql Server. I am executing that same .exe from the remote system via a mapped drive (client:Server) environment. Starting from the same folder in both cases as well.

In an attempt to "cover all bases" I installed the same ODBC connector on the remote system with the same setup but it fails when tested at the System DSN test. Since I am running the .exe from the MySql Server system this does not surprise me - it should not be needed.
Is this a problem of "sharing the connection"? I have tried to implement this with the sqlconnect function after the sqlstringconnect function but sqlconnect complains that I have an invalid connection handle when I am trying to pass the "statement handle". I don't think I have the correct architecture on this test.

I would appreciate any insights on this one. This is my first "walk" in the FoxPro MySql paradigm and I was feeling successful (managed to transfer one table over 50,000 records between the two worlds) until it came time to make the FoxPro MySql connection across the LAN.

Migration from Netezza to MySQL (1 reply)

Hema Tandon — Wed, 13 Jun 2018 17:36:12 +0000

Hi,
We are working to migrate from Netezza to MySQL. Netezza has 'distribute on' clause which helps with data distribution over various processing units. Is there any similar functionality available in MySQL?

Thanks.

Migration from community to commercial edition (2 replies)

shruti nimbalkar — Sat, 05 May 2018 14:45:35 +0000

Is it possible to migrate from community edition to commercial edition without need to re-create the mySQL data.

Converting plaintext file into valid MySQL Format (no replies)

Michael Loaoa — Sun, 01 Oct 2017 22:52:10 +0000

Hello,

I have a document with raw data that i would like to convert into a valid MySQL Format to use in a Wordpress blog.
The raw data must be separated by posts for using in wp_posts table and searchable using the build-in search function.

The raw data is in the following format
email:location:client number:zone

And i want to remove location and zone turning into the format below
email:client number

After that i want to create a valid entry into wp_posts table with row and unfixed location
The formatation of the data must be incremented by plus 1 and the page location must also incremented by plus 1

What tools or macros should i use for this?

Thanks

sql server to mysql database mirroring - Best ways to achieve? (no replies)

Rathi Rao — Tue, 21 Feb 2017 07:33:47 +0000

Hi,

I want to mirror my database in sql server to mysql. I migrate the schema with data to mysql using mysql workbench.

Now, any insert/update/delete on sql server needs to be migrated to mysql as well. I can have difference in data of maximum 10 mins between the 2 databases. Meaning, I will have to keep running a job every 10 mins to monitor the changes in sql server and migrate them to mysql.

What are the ways to achieve this?

Any thoughts on this would be very helpful

Thanks in advance Rathi

convert Mysql to Sqlit (no replies)

Fabi Al Pacino — Thu, 16 Feb 2017 17:35:34 +0000

I'm working on a web application project. I would like to convert my application into android application.
My problem is that my database is MySQL and I would like to convert it to Sqlite so that the android application can run off connection.
What solution do you propose?

sqlite ambiguous SQLiteConnection (1 reply)

Larry Seymour — Fri, 25 Nov 2016 21:47:00 +0000

I am creating an app in C# and while trying to connet to the sqlite db i get this error.

Error CS0121 The call is ambiguous between the following methods or properties:
'SQLiteConnection.SQLiteConnection(string, bool)' and 'SQLiteConnection.SQLiteConnection(string, bool)'
BitesBoardMobile.Droid, BitesBoardMobile.iOS, BitesBoardMobile.WinPhone C:\Users\Larry\documents\visual studio 2015\Projects\BitesBoardMobile\BitesBoardMobile\BitesBoardMobile\controlObject\ControllerData.cs

My code is:
using System;
using SQLite;
using System.IO;

namespace BitesBoardMobile.controlObject
{
public class ControllerData
{
public SQLiteConnection ConnerctToSqLite(string path)
{
var conn = new SQLiteConnection(path);
return conn;
}
}
}

the confusing part to me is on both parts of the ambiguous call it references the same thing.
SQLiteConnection.SQLiteConnection(string, bool)

any idea will be helpful.
thanks

Filemaker Ver 13 to MySQL Migration (1 reply)

Don Crakhou — Tue, 15 Nov 2016 21:36:31 +0000

Hello,

I'm considering migrating a small(2.28meg and 50 records)Filemaker ver 13 DB to MySQL for personal use. Is there a tool to convert to MySQL or would I need to enlist a developer to perform that work? OR, are there tutorials on how to do that myself?

Thanks
Don

Automated conversion of SQLite to MySQL (2 replies)

Paul Karr — Fri, 08 Jul 2016 18:30:11 +0000

Hello, everybody! We have SQLite database that needs to be exported into large MySQL backend database on daily basis. Do you know a solution that can handle this task?

Complied DOS program access to MySQL Server (no replies)

Andrew Gable — Sun, 29 May 2016 17:19:32 +0000

Hi All,

I was wondering if ANYONE has ever managed to get a PURE DOS application talking to a MySQL Remote server?

EXAMPLE

DOS Application ----> TCP/IP ----> MySQL Server

I ask as I have a very good working FreeBASIC application that runs fine on Windows and LInux (new hardware) but I have loads of old Computers that I want to use as information terminal (eg price checking terminals etc)

I did read once that they was a mysql client library for DOS is this still available or does someone have it in their archives?

Thanks

Andy

How to migrate users and Privileges from 5.1.47 to 5.6.27 (1 reply)

Jens Geier — Sat, 19 Dec 2015 12:02:44 +0000

Hello,

I run a MySQL Cummunity Server 5.1.47.

Now I need to migrate all the useres and their privileges to the new MySQL Community Server 5.6.27.

When i migrate the DB mysql with MySQLWorkbench 6.3 than after this work the new DB mysql on the MySQL Server 5.6.27 is bad ....

Does anyone has an idea how to do this work?

There are a lot of users and priviles on the old MySQL Server 5.1.47 that I can not tranfser by hand ...

Kind Regards
Jens Geier

Multi Valued Unique index may cause any performance in MySQL while migrating SQLite to MySQL? (no replies)

KARTHIKEYAN T — Wed, 05 Aug 2015 06:13:24 +0000

Dear Forum Members,
I have migrated the Database from SQ-LITE 1.3 to MySQL ,then try to create an index for three fields single unique key. I have doubt about that multi-valued indexing may cause any performance related issue while InnoDB Table's online transactions and how multiple filed have been accessed in memory physically? Please kindly share your valuable ideas to me

"Export Dbase into MYSQL (no replies)

Gary Tripodi — Mon, 27 Jul 2015 04:23:01 +0000

I just spent quite a bit of time creating a SUB that would maintain field names and most types/formatting. This uses ADODB connections to gather and create database in mysql and loop through DBF resultset inserting values into the MYSQL database. As it is this will need modification on any date values within strVals. Works good for me so far. Heres the script

Sub ExportDBFtoMYSQL

'=================ADODB Constants==============
Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adOpenKeyset = 1
Const adLockReadOnly = 1
Const adOpenForwardOnly = 0

'============MYSQL SERVER VALUES============
MYSQLSVR = "localhost"
MYSQLUSERNAME = "root"
MYSQLPWD = "mypwd"
MYSQLDB = "mrp"
MYSQLUSERNAME = "root"
MYSQLPORT = "3306"

'==================DBF VALUES=================
DBFPath = CurrentDocument.Path
DBFName = "parts"
DBFKey = "IN_HOUSE_S"

'Connect to DBF=================================
Set DBFconn=CreateObject("ADODB.Connection")
Set DBFRS = CreateObject("ADODB.Recordset")
DBFconn.Open "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=" & DBFPath
DBFstrSQL = "SELECT * FROM " & DBFName
DBFRS.Open DBFstrSQL,DBFconn, 0,3

'BUILD MYSQL Col String==============================
i = 0
Do Until i = DBFRS.Fields.Count
If DBFRS.Fields(i).Type = 2 Then
StrCol = StrCol & DBFRS.Fields(i).Name &" SMALLINT(" & DBFRS.Fields(i).DefinedSize & ") DEFAULT NULL, "
strRSCols = strRSCols & "`" & DBFRS.Fields(i).Name & "`" & ","
End If
If DBFRS.Fields(i).Type = 5 Then
StrCol = StrCol & DBFRS.Fields(i).Name &" Numeric(10,4) DEFAULT NULL, "
strRSCols = strRSCols & "`" & DBFRS.Fields(i).Name & "`" & ","
End If
If DBFRS.Fields(i).Type = 200 Then
StrCol = StrCol & DBFRS.Fields(i).Name & " VARCHAR(" & DBFRS.Fields(i).DefinedSize & ") DEFAULT NULL, "
strRSCols = strRSCols & "`" & DBFRS.Fields(i).Name & "`" & ","
End If
If DBFRS.Fields(i).Type = 11 Then
StrCol = StrCol & DBFRS.Fields(i).Name & " BIT(1) DEFAULT NULL, "
strRSCols = strRSCols & "`" & DBFRS.Fields(i).Name & "`" & ","
End If
If DBFRS.Fields(i).Type = 133 Then
StrCol = StrCol & DBFRS.Fields(i).Name & " DATE DEFAULT NULL, "
strRSCols = strRSCols & "`" & DBFRS.Fields(i).Name & "`" & ","
End If
If DBFRS.Fields(i).Type = 201 Then
StrCol = StrCol & DBFRS.Fields(i).Name & " MEDIUMTEXT, "
strRSCols = strRSCols & "`" & DBFRS.Fields(i).Name & "`" & ","
End If
i=i+1
Loop

'Fix MYSQL RSCOL string==================================================
strRSCols = Left(strRSCols,Len(strRSCols)-1) & ")"

'Connect To MYSQL====================================
Set MYSQLConn = CreateObject("ADODB.Connection")
Set MYSQLRS = CreateObject("ADODB.Recordset")
MYSQLstrSQL = "SELECT * FROM " & DBFName
StrMYSQLConn ="Driver=MySQL ODBC 5.3 ANSI Driver;" &_
"SERVER=" & MYSQLSVR &";" &_
"UID=" & MYSQLUSERNAME &";" &_
"PASSWORD=" & MYSQLPWD &";" &_
"DATABASE=" & MYSQLDB & ";" &_
"PORT=" & MYSQLPORT

MYSQLConn.Open StrMYSQLConn

'BUILD MYSQL Create Table String=====================
MYSQLStrExe = "CREATE TABLE " & DBFName & " (" & StrCol & _
"PRIMARY KEY " & DBFName & "_idx1 (" & DBFKey & ")" &_
") ENGINE=InnoDB DEFAULT CHARSET=utf8;"

'EXECUTE MYSQL Create Table====================
MYSQLconn.Execute MYSQLStrExe

'OPEN New MYSQL Table=====================
MYSQLRS.Open MYSQLstrSQL,MYSQLConn, 0,3

'Enter The Data=====================================
If DBFRS.EOF = False Then

SelInto = "INSERT IGNORE INTO " & MYSQLDB & "." & DBFName & "("
i = 0
Do Until DBFRS.EOF = True
strVals = ""
Do Until i = DBFRS.Fields.Count
strVals = strVals & |"| & DBFRS.Fields(i).Value & |"| & ","
i = i + 1
Loop
i = 0

'Print DBFRS.Fields("recid").Value
strVals = Left(strVals,Len(strVals)-1) & ")"
'Print strVals
'Print SelInto & strRSCols & " values" & "(" & strVals

MYSQLconn.Execute SelInto & strRSCols & " values" & "(" & strVals
DBFRS.MoveNext
Loop
End If

MYSQLRS.Close
Set MYSQLRS = Nothing
MYSQLConn.Close
Set MYSQLConn = Nothing

DBFRS.Close
Set DBFRS = Nothing
DBFconn.close
Set DBFconn = Nothing
End Sub