Search the Community
Showing results for tags 'bash script create xml mysql'.
Found 1 result
-
i need to generate an xml file from database records, and i get the error out of memory... here's the script i am using, it's found on google, and it's not suitable for me... and it's also killing the server allocated memory... (but it's a beginning) #!/usr/bin/perl use warnings; use strict; use XML::Simple; use DBI; my $dbh = DBI->connect('DBI:mysql:db_name;host=host_address','db_user','db_pass') or die DBI->errstr; # Get an array of hashes my $recs = $dbh->selectall_arrayref('SELECT * FROM my_table',{ Columns => {} }); # Convert to XML where each hash element becomes an XML element my $xml = XMLout( {record => $recs}, NoAttr => 1 ); print $xml; $dbh->disconnect; this script only print the records, because i tested with an where clause for a single row id... first of all i couldn't manage to make it to save the output to a file.xml (i have no idea how to do it) second, i need somehow to split the "job" in multiple jobs and then put together the xml file all in one piece. (i have no idea, and couldn't find any info on google) thanks for all your answers in advance! PS: i don't have access to change server settings