Selling a few hundred clients, easiest way to migrate whmcs data?

[subigo]

Maybe I'm missing it, but is there an easy way to export all of the client information for certain servers only? I'm thinking of selling 3 servers to another company with a total of about 300 clients on them all together. The other company also uses whmcs. Basically, I need a way to export all of the client information for them... plan details, packages, customer addresses, etc...

 

Even if it's just a spreadsheet or something, what would be the easiest way to extract just this information for them?

 

Keep in mind that I can't just give them a dump of the whmcs database, we have thousands of clients and they are just getting a few hundred of them.

[bear]

You can probably do a dump from phpmyadmin by using a where clause.

Select * FROM * WHERE `table.server` = 'server number'

(table names and fields will vary, obviously)

Once you get this displayed in phpmyadmnin and the data is correct, export it as CSV.

[keliix06]

That's how you'd have to do it, but I imagine it would need to be a much more complex query joining tables in based on client ids, package ids, etc.

[UH-Matt]

It would certainly be cool to come up with a script for this purpose (able to export and import to the database of whmcs based on selection criteria (package names or groups or server names or groups).

[othellotech]

Maybe I'm missing it, but is there an easy way to export all of the client information for certain servers only?

 

Yes, copy the db, then delete the servers you're not selling, delete the tblhosting records from the db that were on those servers, delete the clients that dont have a package, delete the emails that donthave a client, delete the tickets that dont have a client ...