shuttle-export
shuttle-export copied to clipboard
Pure PHP MySQL dumping utility
converted mysql to mysqli wherever felt necessary.
As the UTF-8 byte-order mark is \xef\xbb\xbf we should add it to the document's header. https://stackoverflow.com/questions/6336586/fwrite-and-utf8
As title, it seems that the `mysql_*` functions are deprecated/removed since PHP version is `7.0`. And we should consider using the `PDO` and `MySQLi` to be compatible with `PHP-7.x` versions.
Hi there! First: Awesome script. its really handy. I have an issue regarding special characters. When I export, and then check the sql (and want to import), i see all...
Line 469: From: $res = $this->connection->query($q); To: $res = $this->connection->query($q, MYSQLI_USE_RESULT); You will be able to store MUCH MUCH MUCH more before runing out of memory.
Is there any way to use custom ports, since some budget hosts have not localhost but something like 'remote_server_bla_bla:3313' ? Thanks in advance)
You must pass ```$options['db_port']``` on Shuttle_Dumper inicialization, to specify port.
if some column is setted to utf8mb4 to support emoji. the emoji will be dumped as ?????.
When tables names contain special characters ('-' in my case), the line 230 fails, you need to escape the name with `, the ligne should then be : $tables =...