Now, rename the backup folder located inside the mysql folder on your C drive to data. Open the data_old folder and copy all the database folders inside it and the ibdata1 file.

An XML file displays rows and columns you retrieve from a MySQL database. Using PHP, you can export data from a database table to a Web form. PHP transforms the rows and columns to standard XML ...

To query a MySQL database, I'm going to assume you already have a Windows MySQL server and a database with at least one table in it you'd like to retrieve. I'm also going to assume that you don't ...

I think there may be some confusion of terminology here regarding what "running on NFS" means. Are we talking 1) The MySQL database files are stored on an NFS-mounted directory, or ...

Probably a badly worded title, but we'll see where this goes...I have a reasonably large MySQL database (8GB MyISAM data, 1.2GB indexes) that holds statistical data. The data is inserted on a half ...

JPA 3 and Hibernate persistence.xml file. As developers migrate their old Java Persistence API applications to JPA 3, their progress is often halted when an incorrectly configured JPA 3 ...

Not only have you configured MySQL 8 for remote connections, you’ve also created a user with access to all databases and connected to the remote server with both the command line and a GUI.

At this point, I also needed to configure one of our database servers to allow remote logins. This is done by setting the bind-address variable in the /etc/mysql/my.cnf file to the IP address of the ...

Simply untarring the MySQL database files into Nusphere MySQL's data directory brought up the database and added it to the phpMySQLadmin menu.

Simply untarring the MySQL database files into Nusphere MySQL's data directory and brought up the database and added it to the phpMySQLadmin menu.