True Light Designs Blog

How to duplicate | copy a Magento Database with SSH

Tuesday, 30 December 2014 22:41

Tim Ramsey

0 Comments

I was a bit hopeful with phpMyAdmin “Synchronize”, but Magento’s databases are apparently too big for it because I ended up with white screens and partial uploads. I resorted to using SSH and doing it over command line. Two lines of code and you can export from your live database and import into a production database. Here you go. Export

mysqldump -u username -p database_name > dump.sql

1	mysqldump -u username -p database_name > dump.sql

Import

mysql -u username -p target_database_name < dump.sql

1	mysql -u username -p target_database_name < dump.sql

Hopefully saved you some time and frustration 🙂

How to change “Date Modified” in Windows with PowerShell

Tuesday, 11 November 2014 20:24

Tim Ramsey

0 Comments

I was doing some development locally and needed to change the file time on some files so I could delete certain files in a directory. Below is the code I used to change the files modified time:

$a = Get-Item C:\file-in-question.txt
$b = Get-Date "11/10/2014 8:00 AM"
$a.LastWriteTime = $b

$a = Get-Item C:\file-in-question.txt

$b = Get-Date "11/10/2014 8:00 AM"

$a.LastWriteTime = $b

Hopefully you find this as useful as I did!

Couple of useful Powershell commands

Sunday, 10 August 2014 18:01

Tim Ramsey

0 Comments

Write all contents of folder to a .txt file. Helpful if you have a folder of images and need a .txt list

Get-ChildItem C:\img | ForEach-Object { $_.Name } > C:\img\ims.txt

1	Get-ChildItem C:\img \| ForEach-Object { $_.Name } > C:\img\ims.txt

Recursive find query. Super helpful to find code snippets within a local project

Get-ChildItem "C:\inetpub\tlwchurch" -recurse | Select-String -pattern "navigation->child_link" | group path | select name

1	Get-ChildItem "C:\inetpub\tlwchurch" -recurse \| Select-String -pattern "navigation->child_link" \| group path \| select name

Suspicious process running under user

Wednesday, 30 July 2014 04:56

Tim Ramsey

0 Comments

I was tired of getting WHM email for processes that I was very much aware that were running. You can add these to the ignore file to relieve the excessive emails. Mine happened to be a php program so the syntax is as follows. Open up the file

/etc/csf/csf.pignore

1	/etc/csf/csf.pignore

and add:

cmd:/usr/bin/php /home/<user>/public_html/<yourfile>.php

1	cmd:/usr/bin/php /home/<user>/public_html/<yourfile>.php

then you just need to restart the service for your changes to take effect.

service lfd restart

1	service lfd restart

Page 11 of 13

How to duplicate | copy a Magento Database with SSH

How to change “Date Modified” in Windows with PowerShell

Couple of useful Powershell commands

Suspicious process running under user

Categories

Recent Posts