PHP Classes

.sql files?

Recommend this page to a friend!

      Database structure synchronizer  >  All threads  >  .sql files?  >  (Un) Subscribe thread alerts  
Subject:.sql files?
Summary:This does not work when comparing to .sql files
Messages:2
Author:Charles Wilkins IV
Date:2015-05-15 16:40:08
 

  1. .sql files?   Reply   Report abuse  
Picture of Charles Wilkins IV Charles Wilkins IV - 2015-05-15 16:40:08
I was hoping to use this to compare my local machine to our dev server. i wrote a script that creates a .sql file from each database figuring I would then use your class to get the variances and provide the appropriate SQL statements to update.

That does not seem to be the case.

Thus, what file needs to be created for each database to make comparisons and have your class work properly?

  2. Re: .sql files?   Reply   Report abuse  
Picture of Dave Smith Dave Smith - 2015-05-17 03:50:42 - In reply to message 1 from Charles Wilkins IV
Looks like the author hasn't replied to a question from last year, so I am not sure he will. I did take a look at the instructions and will make the following recommendations.

1) Use phpMyAdmin to dump the tables and data. It sounds like you wrote your own script to create the sql file and the class indicates it needs the create table structure in the file.

2) The class will return an array of sql statements or a string which can be used a sql file to synchronize the tables.

I haven't tested the class myself, just thought I would check it out and throw in my two cents in case the author doesn't get back to you.

Dave