Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Intermediate WordPress Dev Workflow: FILEZILLA,...

Intermediate WordPress Dev Workflow: FILEZILLA, SEQUEL PRO / WORKBENCH presented by KB

In the presentation, I’ll cover the following:

1. Let’s reflect on Local: Highlights from Basic (https://speakerdeck.com/wpnigeria/local-by-kabolobari-benakole)

2. When is a website live?

3.

• Part I: File Manager

• Part II: Database

4. Accessing your site files the traditional way is a pain. Let’s see how.

5. Accessing your site database the traditional way is just as painful. Let’s see how.

6. FileZilla, an FTP software, rescues us with file management

7. Sequel Pro, a Remote MySQL software, rescues us with database management

8. Let’s put FileZilla to work

9.

• Download FileZillaSet up FTP accounts at server

• Create sites with FileZilla Site Manager

• Manually

Using the configuration file

Going back and forth your files, it’s that easy.

10. Let’s put Sequel Pro to work, for Mac users

11.

• Download Sequel Pro to local machine

• Setting remote MySQL

Going back and forth your database

The only edit you’ll ever do on your SQL file

12. Let’s put Workbench to work, for Windows users

13.

• Download Workbench

• Set up remote MySQL

Go back and forth your database

14. You’re Live & Local

Thank you

Questions

Avatar for WordPress Nigeria Community

WordPress Nigeria Community

November 02, 2017
Tweet

More Decks by WordPress Nigeria Community

Other Decks in Technology

Transcript

  1. FILEZILLA, SEQUEL PRO / WORKBENCH Intermediate WordPress Dev Workflow: Kabolobari

    Benakole, @Kabolobari Experience Manager, Softcom Oct 28 - 11 am
  2. Let’s reflect on Local: highlights from Basic Intermediate WordPress Dev

    Workflow: FILEZILLA, SEQUEL PRO / WORKBENCH </Softcom> @Kabolobari
  3. When is a website live? Part I: File Manager Part

    II: Database Intermediate WordPress Dev Workflow: FILEZILLA, SEQUEL PRO / WORKBENCH </Softcom> @Kabolobari
  4. Part I: File Manager So, let's look at accessing a

    website's file and folders the traditional way. It's a pain to do things this way... Intermediate WordPress Dev Workflow: FILEZILLA, SEQUEL PRO / WORKBENCH </Softcom> @Kabolobari
  5. Part II: Database Now we're gonna create an actual database

    and see how we would otherwise go back and forth in it with our tables every time we made updates. This, too, is a pain. Intermediate WordPress Dev Workflow: FILEZILLA, SEQUEL PRO / WORKBENCH </Softcom> @Kabolobari
  6. Part II: Database Now we're gonna create an actual database

    and see how we would otherwise go back and forth in it with our tables every time we made updates. This, too, is a pain. Intermediate WordPress Dev Workflow: FILEZILLA, SEQUEL PRO / WORKBENCH </Softcom> @Kabolobari
  7. Let’s put FileZilla to work 1. Download FileZilla 2. Set

    up FTP accounts at server 3. Create sites with FileZilla Site Manager 1. Manually 2. Using the configuration file 4. Going back and forth your files, it’s that easy. Intermediate WordPress Dev Workflow: FILEZILLA, SEQUEL PRO / WORKBENCH </Softcom> @Kabolobari
  8. Let’s put Sequel Pro to work 1. Download Sequel Pro

    to local machine 2. Setting remote MySQL 3. Going back and forth your database 4. The only edit you’ll ever do on your SQL file Intermediate WordPress Dev Workflow: FILEZILLA, SEQUEL PRO / WORKBENCH </Softcom> @Kabolobari
  9. Let’s put Workbench to work, Windows peeps 1. Download Workbench

    2. Set up remote MySQL 3. Go back and forth your database Intermediate WordPress Dev Workflow: FILEZILLA, SEQUEL PRO / WORKBENCH </Softcom> @Kabolobari
  10. ?