next »

[jammaster82]

Okay i have this .gz file , usually i would import it through php my admin... without php my
admin how would you unzip this and insert it through php?    The dump file is 1.3mb and
looks to contain everything needed to recreate the database... how would a non tard approach this?

lol

 

[perkiset]

First, tar -xzvf (thefile).tar.gz.

Can you run MySQL (the command line app)? This is how we did it when we were still hiking 2 miles to school everyday in the snow.
You'll need to SSH into your box, then run mysql. You'll get a dot prompt or > prompt. Use the "source" command like this:

mysql> use mydatabase
mysql> source /usr/local/jmm/myfile.sql

and that should do it.

[vsloathe]

mysql -u [USERNAME] -p [DATABASE_NAME] < [INPUT FILE]

[jammaster82]

Code:

$buff = file_get_contents($thisfilename);

 $myArr = explode(chr(59), $buff);
 $i = 0;   
 foreach($myArr as $line)
 {
     
   $db->query($line); 
   $lasterror = $db->error();
    if (!$lasterror) {
           // log it succeeded..
        }
                        else
                {
          // log that it failed...

                }       

  $i++;


 }

Okay so i am exploding the $buff on the  semicolon and im getting
individual lines of sql successfully..

My question is more theory in action / design.... considering that i want
this app to run over and over to grab any sort of new data in any sql dump...
im gonna want to store and find out later what sql statements/lines did or didn't get inserted so i can go back and reconcile them.

The question is, what method to use to store the success/failure... a few come to mind, csv file, xml file.... What would be the best method of storing the information about which queries did or didnt work so i could go back and reference them later?

[perkiset]

Sounds an awfully lot like an instance where master->slaving would be a much better solution. That's exactly what the MySQL slave solution does, and quite well I might add.

IMO, keeping your own sync log is just reinventing a really big wheel.

[jammaster82]

I wish!  Im trying to migrate users from phpBB to wordpress
so i have to do this by hand im thinking... still researching it
though... I thought id just chew up the sql and insert it throw
all the errors into a file...


edit:  All i get is a .gz dump of the old databases.....

[perkiset]

migrate or integrate? I did a little work like that for SMF and wordpress. I wrote an intermediate table that linked the WP records to the SMF records and poof! had my answer.

[jammaster82]

Gotta move the users and posts over to wordpress... .. i see a wp_users
table in the wordpress db.... is there something else besides just inserting a
user into the wp_users table?

[perkiset]

Nope, it's all pretty straight up. If you keep a table of user_ids that you've moved, then you'd know what you've already bridged.I assume this is going to be an ongoing process...?

[jammaster82]

Usually they always are ongoing processes, arent they?

Im still stuck on insert... master slaving isnt an option
cause i am the slave i suppose.. hahaha

Right now im looking through a 'didntmakeit.txt' file
I dont even know how to google this error...

trying to insert the SQL:

the sql has a

&#187;

in it so its splitting that sql line that contains html on
that semicolon...  in it
and ending the mysql statement, so i cant just split it on
the semicolons..   

so what do i do now, search and replace all the semicolons that
are inside of quotes after  insert*into*values types of lines?
Then wont i also run into a double quote issue or escape strings
or .... okay im having a panic attack here i need four miller lites and two xanax

 

Seriously though, what am i looking at with this architecture and in inserting and parsing and storing and just generally dealing with storing html in databases..

seperately how about storing html in xml and would this be the same processes?

[jammaster82]

wtf is this &#187; and what do i do with it?!?!

[jammaster82]

Ok so it turns out the #187; is some html for displaying a >> kind of graphic or whatever...

so that kills my splitting it on the semicolons...
what should i do search replace #0; through #255; with a
temporary symbol then split on the semicolons?
this way i could still split on the semicolons and then just re-replace
this when i deal with it as an individual line?

[jammaster82]

and it looks like its more than just 0-255 it could
be &#8217;

in tparser it would be:

Code:

)\&\#n\;;=somethingiwanttotemporarilyreplace

-- collect until you find a literal ampersand, a literal pound sign, any number of numbers 0-9 and followed by literally a semicolon into a named collection record called somethingiwanttotemporarilyreplace

how would i do this with php?

so is replacing this temporarily the best plan and
how is the best way to replace this in php.. it looks
like im gonna be storing html and xml so i better
deal with this and get it out of the way..

[nutballs]

preg_replace('|#(\d+);|','##$1##',$yourstring);
then to switch back
preg_replace('|##(\d+)##|','#$1;',$yourstring);

something like that.
I am multitasking. but thats the basic idea. syntax is probably wrong. lol

[jammaster82]

okay ugh... still on this one this query worked in the phpmyadmin window but when im trying to do it  in mysql command line its giving me the following error:

Code:

insert into wp_users_final1
    -> (
    ->
    ->   user_id,
    ->   user_login,
    ->   user_pass,
    ->   user_nicename,
    ->   user_email,
    ->   user_registered,
    ->   user_activation_key,
    ->   user_status,
    ->   display_name
    ->
    -> )
    ->
    -> values
    ->
    -> (
    -> SELECT
    ->   user_id+94,
    ->   user_login,
    ->   user_pass,
    ->   user_nicename,
    ->   user_email,
    ->   user_registered,
    ->   user_activation_key,
    ->   user_status,
    ->   display_name
    ->
    -> FROM aaatest2
    -> )
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT
  user_id+94,
  user_login,
  user_pass,
  user_nicename,
  user_email,
 ' at line 19

Any ideas why it would work in one and not the other? maybe another set of eyes will help me see what im missing?