chanhvuong.com Report : Visit Site

Technical data of the chanhvuong.com

Geo IP provides you such as latitude, longitude and ISP (Internet Service Provider) etc. informations. Our GeoIP service found where is host chanhvuong.com. Currently, hosted in United States and its service provider is Digital Ocean Inc. .

HTTP Header Analysis

HTTP Header information is a part of HTTP protocol that a user's browser sends to called nginx/1.4.6 (Ubuntu) containing the details of what the browser wants and will accept back from the web server.

DNS

HtmlToText

a software engineer's journal home about freeware migrate post from one wordpress database to another july 31, 2018 internet no comments i made a mistake and posted a blog entry to the wrong wordpress website. a comment was made before i could manually delete and post it to the other website. while i could just lose that comment, i decided it would be interesting to see if i could manually migrate the post content (with comments) directly from one wordpress mysql database to the other. after looking at the wordpress database schema, i found that i only needed to pull data from two tables and modify a few column values. these are the essentials to keep in mind when migrating a post: the two “wp_posts” and “wp_comments” tables contain the data we need to migrate. for “wp_posts”, we need to modify columns “id”, “post_author” (foreign key to “wp_users” table), and “guid”. for “wp_comments”, we need to modify columns “comment_id”, “comment_post_id”, and “comment_parent” (references “comment_id” for replies). we can ignore tables “wp_postmeta” (contains edit lock info) and “wp_commentmeta” (contains akismet approval data). no need to deal with categories and tags (kept in “wp_term_taxonomy”, “wp_termmeta”, and “wp_terms” tables). we can manually set category (from the default “uncategorized”) and insert tags after the migration. image links in the post will point back at the old wordpress site, so we will need to add the images to the new wordpress site and update the image urls accordingly. before we start, make sure that both the wordpress websites are updated to the same version. (my websites are using the latest wordpress version 4.9.7.) read post from old wordpress database identify the post identifier that you wish to move. if you click on your post header, the url will change to include the identifier. for example, my url is “http://www.chanhvuong.com/3048/how-to-sell-a-used-computer-like-a-car-salesman/” and the post identifier is 3048. # ssh into your server and log into mysql. mysql -u root -p # input your mysql root password if it is not blank # select the <database_name> to read from. mysql > use < database_name > ; # by default, mysql is configured to only support reading/writing files from a "mysql-files" directory. # you could remove this requirement, but i decided to just make use it. mysql > show variables like 'secure_file_priv' ; +------------------+-----------------------+ | variable_name | value | +------------------+-----------------------+ | secure_file_priv | / var / lib / mysql-files / | +------------------+-----------------------+ # output the post content matching <post_id> to a file. mysql > select * from wp_posts where id = < post_id > into outfile '/var/lib/mysql-files/post.txt' ; # output the post comments matching <post_id> to a file. mysql > select * from wp_comments where comment_post_id = < post_id > into outfile '/var/lib/mysql-files/comments.txt' ; insert post into new wordpress database while we could modify the column data in the output files, i decided to do manual overwrites when importing. (you will need to be the root user in order to access “/var/lib/mysql-files/” directory.) # select the <other_database_name> to write to. mysql > use < other_database_name > ; # wordpress orders posts by publish date so insert using next auto-increment post id. # you'll need this to modify the "guid" string below. mysql > select max ( id ) + 1 from wp_posts; # find a user id to use as the "post_author". mysql > select id,user_login,display_name from wp_users; # insert the post into the other database. # set id as null so the next auto-increment value will be used. # select existing <my_user_id> as post_author. # update guid with other wordpress domain and the next auto-increment post id. mysql > load data infile '/var/lib/mysql-files/post.txt' into table wp_posts set id =null, post_author = < my_user_id > , guid = "http://www.<other_domain>.com/?p=<auto_incremended_post_id>" ; inserting comments is problematic because reply comments require the identifier for the parent comment, which doesn’t exist yet. one solution is to lookup the next auto-incremented comment id and then edit the “comments.txt” outfile accordingly before importing. however, because my website is active, some comments could be inserted before i do the import, making all the identifiers in the outfile invalid. the second solution, which i chose, is to import the comments and then manually fix the “comment_parent” identifiers (and the “user_id” which is nonzero for users in “wp_users”). # insert the comments into the other database. # set comment_id as null so the next auto-increment value will be used. # set the comment_post_id to be our <auto_incremented_post_id> from above. mysql > load data infile '/var/lib/mysql-files/comments.txt' into table wp_comments set comment_id =null, comment_post_id = < auto_incremented_post_id > ; # lookup the newly-inserted comments. mysql > select comment_id,comment_author,comment_author_email,comment_parent,user_id from wp_comments where comment_post_id = < auto_incremented_post_id > ; # update comment_parent to the correct comment_id (replace 472365 and 472366 below accordingly). mysql > update wp_comments set comment_parent = 472365 where comment_id = 472366 ; # update user_id for reply comments made by you (replace <my_user_id> and 472366 below accordingly). mysql > update wp_comments set user_id = < my_user_id > where comment_id = 472366 ; fix category, tags, and images the post and comments should now be visible on your other wordpress website. you can set the post’s category and tags using the normal editing process. and add any images and update the image urls in the post body accordingly. once you’re confident that the post is displayed correctly, you can delete its duplicate (and related images) from the old wordpress website. also, you can delete the no longer necessary outfiles from the “/var/lib/mysql-files” directory. and finally, for completeness, set a redirection from the old post url to the new post url. some info above gotten from: save mysql query results into a text or csv file how should i tackle –secure-file-priv in mysql? how to load data infile in mysql with first col being auto increment? no comments fix gps on iphone 6s april 18, 2018 mobile devices no comments two months ago, google maps stopped telling me directions when navigating on my apple iphone 6s. i could still navigate without the voice prompts though. two week ago, my current location would only update once per minute. i couldn’t navigate at all. sometimes, after 5-10 minutes, the gps location updates would start working correctly again. in any case, my gps was broken. (apple maps exhibited the same gps problem.) note: the intermittent gps updates reminded me of the refurbished iphone 5s i got from t-mobile. it would abruptly lose power in very cold weather. later i found out that the phone was missing parts inside, specifically, the metal shield over the battery connector; so during cold weather, some parts must have contracted and shorted the battery out. maybe my gps problem was similar. alas, no parts were missing from the iphone 6s. i thought it was a software bug because i had updated to ios 11.2 near the time the gps started misbehaving. updating to ios 11.3 did not fix the gps problem. i reset the location configuration (under settings, general, reset, reset location & privacy), did a “reset all settings”, and performed a full system restore (using itunes), but none of those actions fixed the gps. after researching, i could only conclude that the gps issue was a hardware problem. most likely, the gps antenna needed to be replaced. tip: if you no longer hear the google maps (or apple maps) navigational voice prompts, then the iphone probably was not able successfully to acquire the gps satellit

URL analysis for chanhvuong.com

http://www.chanhvuong.com/date/2009/07/
http://www.chanhvuong.com/date/2011/01/
http://www.chanhvuong.com/wp-content/uploads/animate_me_timeline.gif
http://www.chanhvuong.com/date/2001/07/
http://www.chanhvuong.com/3242/update-to-latest-ubuntu-kernel/
https://www.chanhvuong.com/download/animate_me.psd
http://www.chanhvuong.com/date/2014/01/
http://www.chanhvuong.com/date/2012/11/
http://www.chanhvuong.com/date/2012/06/
http://www.chanhvuong.com/3179/create-animated-gif-with-photoshop/
http://www.chanhvuong.com/feed/
http://www.chanhvuong.com/date/2017/09/
http://www.chanhvuong.com/date/2001/11/
http://www.chanhvuong.com/date/2014/
http://www.chanhvuong.com/date/2012/10/

Whois Information

Whois is a protocol that is access to registering information. You can reach when the website was registered, when it will be expire, what is contact details of the site with the following informations. In a nutshell, it includes these informations;

Domain Name: CHANHVUONG.COM
Registry Domain ID: 1792862600_DOMAIN_COM-VRSN
Registrar WHOIS Server: whois.namecheap.com
Registrar URL: http://www.namecheap.com
Updated Date: 2018-03-06T19:57:12Z
Creation Date: 2013-04-10T21:37:44Z
Registry Expiry Date: 2020-04-10T21:37:44Z
Registrar: NameCheap Inc.
Registrar IANA ID: 1068
Registrar Abuse Contact Email: [email protected]
Registrar Abuse Contact Phone: +1.6613102107
Domain Status: ok https://icann.org/epp#ok
Name Server: NS1.DIGITALOCEAN.COM
Name Server: NS2.DIGITALOCEAN.COM
Name Server: NS3.DIGITALOCEAN.COM
DNSSEC: unsigned
URL of the ICANN Whois Inaccuracy Complaint Form: https://www.icann.org/wicf/
>>> Last update of whois database: 2018-08-17T21:44:10Z <<<

For more information on Whois status codes, please visit https://icann.org/epp

NOTICE: The expiration date displayed in this record is the date the
registrar's sponsorship of the domain name registration in the registry is
currently set to expire. This date does not necessarily reflect the expiration
date of the domain name registrant's agreement with the sponsoring
registrar. Users may consult the sponsoring registrar's Whois database to
view the registrar's reported date of expiration for this registration.

TERMS OF USE: You are not authorized to access or query our Whois
database through the use of electronic processes that are high-volume and
automated except as reasonably necessary to register domain names or
modify existing registrations; the Data in VeriSign Global Registry
Services' ("VeriSign") Whois database is provided by VeriSign for
information purposes only, and to assist persons in obtaining information
about or related to a domain name registration record. VeriSign does not
guarantee its accuracy. By submitting a Whois query, you agree to abide
by the following terms of use: You agree that you may use this Data only
for lawful purposes and that under no circumstances will you use this Data
to: (1) allow, enable, or otherwise support the transmission of mass
unsolicited, commercial advertising or solicitations via e-mail, telephone,
or facsimile; or (2) enable high volume, automated, electronic processes
that apply to VeriSign (or its computer systems). The compilation,
repackaging, dissemination or other use of this Data is expressly
prohibited without the prior written consent of VeriSign. You agree not to
use electronic processes that are automated and high-volume to access or
query the Whois database except as reasonably necessary to register
domain names or modify existing registrations. VeriSign reserves the right
to restrict your access to the Whois database in its sole discretion to ensure
operational stability. VeriSign may restrict or terminate your access to the
Whois database for failure to abide by these terms of use. VeriSign
reserves the right to modify these terms at any time.

The Registry database contains ONLY .COM, .NET, .EDU domains and
Registrars.

  REGISTRAR NameCheap Inc.

SERVERS

  SERVER com.whois-servers.net

  ARGS domain =chanhvuong.com

  PORT 43

  TYPE domain

DOMAIN

  NAME chanhvuong.com

  CHANGED 2018-03-06

  CREATED 2013-04-10

STATUS
ok https://icann.org/epp#ok

NSERVER

  NS1.DIGITALOCEAN.COM 173.245.58.51

  NS2.DIGITALOCEAN.COM 173.245.59.41

  NS3.DIGITALOCEAN.COM 198.41.222.173

  REGISTERED yes

Mistakes

The following list shows you to spelling mistakes possible of the internet users for the website searched .