Thread: Salesforce PHP MySQL Database Replication Tool

yeah I do! If I remember right you are using the latest toolkit and need to change the for loop or foreach loop inside the store_in_db function

show me your code and I will show you how to correct it!

Cool,

I did go back and get an earlier version of xampp.... and got things working somewhat........it matched the directions given in the toolkit site as well a lot better.....

I will post the code (attached file)..... its pretty much what you had up on this site, with minor mappings/changes.......


I need to take off but will check back in a bit.....

thanks man,

Ahh so you running the sql build script! Why not just use the one here > Salesforce MySQL Schema Build Tool

also it seems that error reporting is not turned on, go to your XAMPP php.ini file and search for error_reporting. See if it is set to display errors, also check your logs to see if you can get the error there.

It is a issue with the different toolkit, one that can be corrected fast if you can somehow find the error

~Mike

This is in the error section......

error_reporting = E_ALL & ~E_NOTICE

I will give the other option a look as well...

thanks,

While I think I have everything setup, the mysql manipulation I am still working through. I did generate the sql file using the tool above..... I remember doing that...... and I also remember running that from within the mysql system/command line........but at the moment the specific command to do so escapes me......

Do you have anything/instructions/etc. that I could use to do so?

Also, once I have the database schema put together, what would you recommend I use to download and populate the data? I assume I would just modify the account extract tool you have to include all fields and tables....... but that does sound like a lot of work......which is I was was using the sql build script earlier..... thought it might be easier.....

In any case.....plugging through and having fun.....

Thanks,

Actually I am working on a new script that is much faster and totally easy to adapt for each object.

Do you use ADOdb? if so, this will be great for you and whatever table and even database you are inserting records too


I will post an example in a few


~Mike

Sounds pretty sweet. I have installed the 3.51 driver, but I am not sure if I have my mysql/php connector working just yet. Hopefully this will work out well. I think I am going to have a lot of fun working with this once I get some good experience with it........and the direction things are going it may be a necessity.

Look forward to it...... still stumbling around in the dark a bit, but getting there.....

By the way, Nice Picture on force.com.....

ha you like that!! How embarrassing