Package com.jk.data.backup

Class MySqlUtil

java.lang.Object

com.jk.data.backup.MySqlUtil

public class MySqlUtil
extends Object

This method class provides utility methods for exporting and importing MySQL database data.

Version:

1.0

Author:

Dr. Jalal H. Kiswani

Constructor Summary

Constructors

Constructor	Description
MySqlUtil()

Method Summary

Modifier and Type	Method	Description
static void	export(DatabaseInfo info)	This exports a MySQL database to a specified SQL file using the provided DatabaseInfo.
static void	importDb(DatabaseInfo info)	This method imports an SQL file into a MySQL database using the provided DatabaseInfo.
static void	main(String[] args)	This main method is for testing purposes.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

MySqlUtil

public MySqlUtil()

Method Details

export

public static void export(DatabaseInfo info)

This exports a MySQL database to a specified SQL file using the provided DatabaseInfo.

Parameters:

info - Specifies the DatabaseInfo containing connection and export details.

importDb

public static void importDb(DatabaseInfo info)
                     throws IOException

This method imports an SQL file into a MySQL database using the provided DatabaseInfo.

Parameters:

info - Specifies the DatabaseInfo containing connection and import details.

Throws:

IOException - if an I/O exception has occurred.

main

public static void main(String[] args)

This main method is for testing purposes.

Parameters:

args - the command-line arguments.