Skip to content

jbrule/Fix-Serialization

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Fix Serialization

A PHP script to fix length attributes for serialized strings over database dumps (e.g. Wordpress databases)

This script can be useful if you perform text replacements in database dumps containing serialized data structures,
so that reconstructs the serialized length attribute and prevents the serialized offset error in code execution.

How to use:

- Execute directly this script in the way:

	- In place file processing
 	/usr/bin/php fix-serialization.php my-sql-file.sql
 	
	- Stream processing Examples

		-- Uncompressed to uncompressed
		cat my-sql-file.sql | /usr/bin/php fix-serialization.php --stream > my-sql-fixed-file.sql

		-- Compressed to compressed
		gunzip < my-sql-file.sql.gz | /usr/bin/php fix-serialization.php --stream | gzip > my-sql-fixed-file.sql.gz
	
		-- Direct import into mysql from compressed
		gunzip < my-sql-file.sql.gz | /usr/bin/php fix-serialization.php --stream | mysql -uuname -p "database name"
	

- Or use the shell script replace.sh that replaces with sed command each sql file in directory and call fix-serialization script

	sh replace.sh

Licensed under the GPL version 3 or later:
http://www.gnu.org/licenses/gpl.txt

Regards,
Pau Iglesias

Blogestudio
http://blogestudio.com/

About

Script to fix length attributes in serialized strings

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • PHP 94.5%
  • Shell 5.5%