cli

A CSS Click action Concertina Menu.

Using just CSS to produce a click action vertical concertina menu with persist and accessibility




cli

A CSS Click to Open/Close Menu #2.

An update to the previous version of the click action multi-level menu with persist.




cli

A CSS Click to Open/Close Dropline Menu.

A click action dropline menu with persist and accessibility.




cli

A CSS Click action Tree Menu.

A click action Tree Menu using just CSS.




cli

A Vertical click to open/close Concertina.

A vertical concertina menu with a click to open and close action and animation.




cli

CSS play - Click, Zoom and Fly Gallery

A gallery with permanent image changes and a zoom/fly animation.




cli

CSS ONLY click open/close action multi-level menu suitable for the iPad etc..

Using just CSS to produce a multi-level menu with a click to open/close action instead of the normal hover suitable for the iPad.




cli

CSSplay - CSS only click/tap multi-level menu with hover fallback

A CSS only click/tap action multi level menu suitable for touch-enabled devices.




cli

CSSplay - CSS click/tap multi level menu

A CSS ONLY click/tap multi level menu for all the latest browsers and OS with fallback for IE7 and IE8.




cli

CSSplay - Responsive CSS click/tap multi level menu

A CSS ONLY responsive click/tap multi level menu for all the latest browsers and OS, PCs, tablets and smartphones.




cli

CSSplay - Responsive CSS click/tap droplist menu

A CSS ONLY responsive click/tap droplist menu for all the latest browsers and OS, PCs, tablets and smartphones.




cli

CSSplay - Responsive CSS click/tap droplist menu - version 2

A second CSS ONLY responsive click/tap droplist menu for all the latest browsers and OS, PCs, tablets and smartphones.




cli

We're all in this together: decisionmaking to address climate change in a complex world

Forests significantly influence the global carbon budget: they store massive amounts of carbon in their wood and soil, they sequester atmospheric carbon as they grow, and they emit carbon as a greenhouse gas when harvested or converted to another use.




cli

Yellow-Cedar Decline In The North Coast Forest District of British Columbia

The distribution of a forest decline of yellow-cedar (Callitropsis nootkatensis (D. Don) Orsted) has been documented in southeast Alaska, but its occurrence in British Columbia was previously unknown. We conducted an aerial survey in the Prince Rupert area in September 2004 to determine if yellow-cedar forests in the North Coast Forest District of British Columbia were experiencing a similar fate as in nearby Alaska. Numerous large areas of concentrated yellow-cedar mortality were found, extending the known distribution of the decline problem 150 km south of the Alaska-British Columbia border. The forests with the most concentrated tree death occurred at 300 to 400 m elevation, frequently on south aspects. The appearance of these forests including proximity to bogs; mixtures of dying, recently killed, and long-dead trees; and crown and bole symptoms of dying trees were all consistent with the phenomenon in southeast Alaska.




cli

Making fire and fire surrogate science available: a summary of regional workshops with clients

Operational-scale experiments that evaluate the consequences of fire and mechanical "surrogates" for natural disturbance events are essential to better understand strategies for reducing the incidence and severity of wildfire. The national Fire and Fire Surrogate (FFS) study was initiated in 1999 to establish an integrated network of long-term studies designed to evaluate the consequences of using fire and fire surrogate treatments for fuel reduction and forest restoration. Beginning in September2005, four regional workshops were conducted with selected clients to identify effective and efficient means of communicating FFS study findings to users. We used participatory evaluation to design the workshops, collect responses to focused questions and impressions, and summarize the results. We asked four overarching questions: (1) Who needs fuel reduction information? (2) What information do they need? (3) Why do they need it? (4) How can it best be delivered to them? Participants identified key users of FFS science and technology, specific pieces of information that users most desired, and how this information might be applied to resolve fuel reduction and restoration issues. They offered recommendations for improving overall science delivery and specific ideas for improving delivery of FFS study results and information. User groups identified by workshop participants and recommendations for science delivery are then combined in a matrix to form the foundation of a strategic plan for conducting science delivery of FFS study results and information. These potential users, their information needs, and preferred science delivery processes likely have wide applicability to other fire science research.




cli

Lichen bioindication of biodiversity, air quality, and climate: baseline results from monitoring in Washington, Oregon, and California

Lichens are highly valued ecological indicators known for their sensitivity to a wide variety of environmental stressors like air quality and climate change. This report summarizes baseline results from the U.S. Department of Agriculture, Forest Service, Forest Inventory and Analysis (FIA) Lichen Community Indicator covering the first full cycle of data collection (1998-2001, 2003) for Washington, Oregon, and California. During this period, FIA conducted 972 surveys of epiphytic macrolichen communities for monitoring both spatial and long-term temporal trends in forest health. Major research findings are presented with emphasis on lichen biodiversity as well as bioindication of air quality and climate. Considerable effort is devoted to mapping geographic patterns and defining lichen indicator species suitable for estimating air quality and climate.




cli

Influence of four tree shelter types on microclimate and seedling performance of Oregon white oak and western redcedar

Four types of tree shelters were evaluated in southwestern Washington for their effects on seedling microenvironment and performance of two tree species. Shelter types were fine-mesh fabric shelters, solid-walled white shelters with and without vent holes, and solid-walled blue unvented shelters. Summer mean and daily maximum air temperatures were increased by 0.8 degrees C and 3.6 degrees C, respectively, in solid-walled tree shelters. Shelter color and shelter venting did not influence air temperatures. Tree shelters only affected vapor pressure deficit late in the growing season. Midday photosynthetically active radiation within shelters ranged from 54 percent of full sun in fine-mesh fabric shelters to 15 percent of full sun in blue solid-walled shelters. In the first year after planting, height and diameter growth of western redcedar (Thuja plicata Donn ex D. Don) were significantly increased by all shelter types, with blue solid-walled shelters resulting in the greatest height growth. However, in blue solid-walled shelters, photosynthesis and stem diameter growth of Oregon white oak (Quercus garryana Dougl. ex Hook.) seedlings were significantly less than for unsheltered seedlings.




cli

Effects of climate change on natural resources and communities: a compendium of briefing papers.

This report is a compilation of four briefing papers based on literature reviews and syntheses, prepared for USDA Forest Service policy analysts and decisionmakers about specific questions pertaining to climate change. The main topics addressed here are effects of climate change on wildlife habitat, other ecosystem services, and land values; socioeconomic impacts of climate change on rural communities; and competitiveness of carbon offset projects on nonindustrial private forests in the United States.




cli

Adapting to climate change at Olympic National Forest and Olympic National Park.

Climate change presents a major challenge to natural resource managers both because of the magnitude of potential effects of climate change on ecosystem structure, processes, and function, and because of the uncertainty associated with those potential ecological effects. Concrete ways to adapt to climate change are needed to help natural resource managers take the first steps to incorporate climate change into management and take advantage of opportunities to counteract the negative effects of climate change. We began a climate change adaptation case study at Olympic National Forest (ONF) in partnership with Olympic National Park (ONP) to determine how to adapt management of federal lands on the Olympic Peninsula, Washington, to climate change. The case study began in the summer of 2008 and continued for 1½ years. The case study process involved science-based sensitivity assessments, review of management activities and constraints, and adaptation workshops in each of four focus areas (hydrology and roads, fish, vegetation, and wildlife). The process produced adaptation options for ONF and ONP, and illustrated the utility of place-based vulnerability assessment and science-management workshops in adapting to climate change. The case study process provides an example for other national forests, national parks, and natural resource agencies of how federal land management units can collaborate in the initial stages of climate change adaptation. Many of the ideas generated through this process can potentially be applied in other locations and in other agencies.




cli

Yellow-cedar decline in the north coast forest District of British Columbia

None of several types of chemotherapeutants applied before inoculation (antibiotics, metallic salts, systemic fungicides) prevented infection of sugar pine seedlings by white pine blister rust. DMSO (dimethyl sulfoxide) did not enhance the action of any material with which it was applied.




cli

Adaptation: Planning for Climate Change and Its Effects on Federal Lands.

National forest managers are charged with tackling the effects of climate change on the natural resources under their care. The Forest Service National Roadmap for Responding to Climate Change and the Climate Change Performance Scorecard require managers to make significant progress in addressing climate change by 2015. To help land managers meet this challenge, Forest Service scientists conducted three case studies on national forests and adjacent national parks and documented a wide range of scientific issues and solutions. They summarized the scientific foundation for climate change adaptation and made the information accessible to land managers by creating a climate change adaptation guidebook and web portal. Case study teams discovered that collaboration among scientists and land managers is crucial to adaptation planning, as are management plans targeted to the particular ecosystem conditions and management priorities of each region.




cli

Climate Change, Carbon, and Forestry in Northwestern North America: Proceedings of a Workshop November 14 - 15, 2001 Orcas Island, Washington

Interactions between forests, climatic change and the Earths carbon cycle are complex and represent a challenge for forest managers - they are integral to the sustainable management of forests. In this volume, a number of papers are presented that describe some of the complex relationships between climate, the global carbon cycle and forests.




cli

Bringing climate change into natural resource management: proceedings.

These are the proceedings of the 2005 workshop titled implications of bringing climate into natural resource management in the Western United States. This workshop was an attempt to further the dialogue among scientists, land managers, landowners, interested stakeholders and the public about how individuals are addressing climate change in natural resource management.




cli

tech. coord. 2010. Economic modeling of effects of climate change on the forest sector and mitigation options: a compendium of briefing papers

This report is a compilation of six briefing papers based on literature reviews and syntheses, prepared for U.S. Department of Agriculture, Forest Service policy analysts and decisionmakers about specific questions pertaining to climate change.




cli

Social vulnerability and climate change: synthesis of literature

The effects of climate change are expected to be more severe for some segments of society than others because of geographic location, the degree of association with climate-sensitive environments, and unique cultural, economic, or political characteristics of particular landscapes and human populations. Social vulnerability and equity in the context of climate change are important because some populations may have less capacity to prepare for, respond to, and recover from climate-related hazards and effects. Such populations may be disproportionately affected by climate change. This synthesis of literature illustrates information about the socioeconomic, political, health, and cultural effects of climate change on socially vulnerable populations in the United States, with some additional examples in Canada. Through this synthesis, social vulnerability, equity, and climate justice are defined and described, and key issues, themes, and considerations that pertain to the effects of climate change on socially vulnerable populations are identified. The synthesis reviews what available science says about social vulnerability and climate change, and documents the emergence of issues not currently addressed in academic literature. In so doing, the synthesis identifies knowledge gaps and questions for future research.




cli

Responding to climate change in national forests: a guidebook for developing adaptation options.

This guidebook contains science-based principles, processes, and tools necessary to assist with developing adaptation options for national forest lands. The adaptation process is based on partnerships between local resource managers and scientists who work collaboratively to understand potential climate change effects, identify important resource issues, and develop management options that can capitalize on new opportunities and reduce deleterious effects. Because management objectives and sensitivity of resources to climate change differ among national forests, appropriate processes and tools for developing adaptation options may also differ.




cli

Exploring the role of traditional ecological knowledge in climate change initiatives

Indigenous populations are projected to face disproportionate impacts as a result of climate change in comparison to nonindigenous populations. For this reason, many American Indian and Alaska Native tribes are identifying and implementing culturally appropriate strategies to assess climate impacts and adapt to projected changes. Traditional ecological knowledge (TEK), as the indigenous knowledge system is called, has the potential to play a central role in both indigenous and nonindigenous climate change initiatives. The detection of environmental changes, the development of strategies to adapt to these changes, and the implementation of sustainable land-management principles are all important climate action items that can be informed by TEK. Although there is a significant body of literature on traditional knowledge, this synthesis examines literature that specifically explores the relationship between TEK and climate change. The synthesis describes the potential role of TEK in climate change assessment and adaptation efforts. It also identifies some of the challenges and benefits associated with merging TEK with Western science, and reviews the way in which federal policies and administrative practices facilitate or challenge the incorporation of TEK in climate change initiatives. The synthesis highlights examples of how tribes and others are including TEK into climate research, education, and resource planning and explores strategies to incorporate TEK into climate change policy, assessments, and adaptation efforts at national, regional, and local levels.​




cli

Assessing the vulnerability of watersheds to climate change: results of national forest watershed vulnerability pilot assessments

Existing models and predictions project serious changes to worldwide hydrologic processes as a result of global climate change. Projections indicate that significant change may threaten National Forest System watersheds that are an important source of water used to support people, economies, and ecosystems. Wildland managers are expected to anticipate and respond to these threats, adjusting management priorities and actions. Because watersheds differ greatly in: (1) the values they support, (2) their exposure to climatic changes, and (3) their sensitivity to climatic changes, understanding these differences will help inform the setting of priorities and selection of management approaches. Drawing distinctions in climate change vulnerability among watersheds on a national forest or grassland allows more efficient and effective allocation of resources and better land and watershed stewardship. Eleven national forests from throughout the United States, representing each of the nine Forest Service regions, conducted assessments of potential hydrologic change resulting from ongoing and expected climate warming. A pilot assessment approach was developed and implemented. Each national forest identified water resources important in that area, assessed climate change exposure and watershed sensitivity, and evaluated the relative vulnerabilities of watersheds to climate change. The assessments provided management recommendations to anticipate and respond to projected climate-hydrologic changes. Completed assessments differed in level of detail, but all assessments identified priority areas and management actions to maintain or improve watershed resilience in response to a changing climate. The pilot efforts also identified key principles important to conducting future vulnerability assessments.




cli

New report provides conservation and management strategies for climate-sensitive yellow-cedar in Alaska

The U.S. Forest Service's Pacific Northwest Research Station today released a new report that outlines a climate adaptation strategy for yellow-cedar in Alaska.




cli

Climate change vulnerability and adaptation in the North Cascades region, Washington.

The North Cascadia Adaptation Partnership (NCAP) is a science-management partnership consisting of the U.S. Department of Agriculture Forest Service Mount Baker-Snoqualmie and Okanogan-Wenatchee National Forests and Pacific Northwest Research Station; North Cascades National Park Complex; Mount Rainier National Park; and University of Washington Climate Impacts Group.




cli

A climate adaptation strategy for conservation and management of yellowcedar in Alaska

A conservation and management strategy for yellow-cedar in Alaska is presented in the context of climate change.




cli

Climate change through an intersectional lens: gendered vulnerability and resilience in indigenous communities in the United States

Over the past decade, wood-energy use in Alaska has grown dramatically.




cli

Climate change vulnerability and adaptation in the Blue Mountains.

The Blue Mountains Adaptation Partnership was developed to identify climate change issues relevant to resource management in the Blue Mountains region, to find solutions that can minimize negative effects of climate change, and to facilitate transition of diverse ecosystems to a warmer climate.




cli

Climate change vulnerability assessment for the Chugach National Forest and the Kenai Peninsula.

This assessment evaluates the effects of future climate change on a select set of ecological systems and ecosystem services in Alaska’s Kenai Peninsula and Chugach National Forest regions. The focus of the assessment was established during a multi-agency/organization workshop that established the goal to conduct a rigorous evaluation of a limited range of topics rather than produce a broad overview.




cli

Lichen communities as climate indicators in the U.S. Pacific States.

Epiphytic lichens are bioindicators of climate, air quality, and other forest conditions and may reveal how forests will respond to global changes in the U.S. Pacific States of Alaska, Washington, Oregon, and California. We explored climate indication with lichen communities surveyed by using both the USDA Forest Service Forest Inventory and Analysis (FIA) and Alaska Region (R10) methods. Across the Pacific States, lichen indicator species and ordination “climate scores” reflected associations between lichen community composition and climate. Indicator species are appealing targets for monitoring, while climate scores at sites resurveyed in the future can indicate climate change effects.




cli

Adaptations to climate change: Colville and Okanogan-Wenatchee National Forests.

Forest managers are seeking practical guidance on how to adapt their current practices and, if necessary, their management goals, in response to climate change. Science-management collaboration was initiated on national forests in eastern Washington where resource managers showed a keen interest in science-based options for adapting to climate change at a 2-day workshop. Scientists and managers reviewed current climate change science and identified resources vulnerable to expected climate change. Vulnerabilities related to vegetation and habitat management included potential reductions in forest biodiversity and low forest resilience to changing disturbance regimes. The vulnerabilities related to aquatic and infrastructure resources included changing water quality and quantity, the risk to roads and other facilities from changes to hydrologic regimes, and the potential loss of at-risk aquatic species and habitats. Managers then worked in facilitated groups to identify adaptations that could be implemented through management and planning to reduce the vulnerability of key resources to climate change. The identified adaptations were grouped under two major headings: Increasing Ecological Resiliency to Climate Change, and Increasing Social and Economic Resiliency to Climate Change. The information generated from the science-management collaborative represents an initial and important step in identifying and prioritizing tangible steps to address climate change in forest management. Next would be the development of detailed implementation strategies that address the identified management adaptations..




cli

See Daniel Radcliffe read Harry Potter as wizard world opens new online chapter

Film star Daniel Radcliffe launches new Harry Potter at Home series with the first celebrity video reading




cli

Three NI recycling centres have reopened to the public

It has been two weeks since Executive issued guidelines for reopening




cli

West Belfast lad cycling round Falls Park every day to raise money for hospice

Rossa Doherty asked his mummy what he could do to help after seeing




cli

Clint Marsh Adds SVP Stripes At Futuri Media

CLINT MARSH has been promoted to SVP/Product at CLEVELAND-based FUTURI MEDIA. He joined the company in 2016 as Partner Integration Specialist (NET NEWS 7/25/2016), and was promoted to … more




cli

Cliftonville announce contract extension for Thomas Maguire

He made his debut in August 2018 and has gone on to make 52 appearances for the Reds.




cli

Maryland Association of School Librarians awarded AASL ABC-CLIO Leadership Grant

CHICAGO – The Maryland Association of School Librarians (MASL) is the recipient of the 2020 American Association of School Librarians’ (AASL) ABC-CLIO Leadership Grant. Sponsored by ABC-CLIO, the $1,750 grant is given to an AASL Chapter for planning and implementing leadership programs at the state, regional, or local level.




cli

Growing cardiovascular genetics field calls for special multidisciplinary clinical programs to better identify and treat inherited heart conditions

Statement Highlights: In a new scientific statement, the American Heart Association supports the creation of specialized multidisciplinary clinical programs that combine cardiovascular medicine and genetics expertise. These specialized programs would use genetic information to better treat patients with inherited heart conditions, as well as assess family members without current heart problems and take steps to reduce their risk.




cli

Better science needed to support clinical predictors that link cardiac arrest, brain injury, and death: a statement from the American Heart Association

Statement Highlights: While significant improvements have been made in resuscitation and post cardiac arrest resuscitation care, mortality remains high and is mainly attributed to widespread brain injury.Better science is needed to support the ...






cli

Search Engine Optimization – How to Double Your Client’s Organic Traffic

The business world has changed over the years and you’ll need to rely on digital methods of marketing your brand to succeed. One of the best ways to do that is through search engine optimization (SEO) to get better traffic for your business. When you use the right techniques and strategies, you can double your organic traffic.  If you’re in the business of helping people with their search engine optimization needs, here are some of the best ways to double your client’s organic traffic. Help Clients Work On Their Content You need to teach and advise your clients on how

The post Search Engine Optimization – How to Double Your Client’s Organic Traffic appeared first on Photoshop Lady.




cli

Why it’s a Bad Idea to Over-Customize Client Website Templates

Web clients love custom designs. Enough unique changes can turn a pre-made template into a beautiful, original site design. While there’s nothing wrong with tweaking a website for your clients, customization can be taken too far.   Granting excessive requests can put your projects into overtime and drive you mad. If you want to avoid […] More




cli

How to Foster Real-Time Client Engagement During Moderated Research

When we conduct moderated research, like user interviews or usability tests, for our clients, we encourage them to observe as many sessions as possible. We find when clients see us interview their users, and get real-time responses, they’re able to learn about the needs of their users in real-time and be more active participants in the process. One way we help clients feel engaged with the process during remote sessions is to establish a real-time communication backchannel that empowers clients to flag responses they’d like to dig into further and to share their ideas for follow-up questions.

There are several benefits to establishing a communication backchannel for moderated sessions:

  • Everyone on the team, including both internal and client team members, can be actively involved throughout the data collection process rather than waiting to passively consume findings.
  • Team members can identify follow-up questions in real-time which allows the moderator to incorporate those questions during the current session, rather than just considering them for future sessions.
  • Subject matter experts can identify more detailed and specific follow-up questions that the moderator may not think to ask.
  • Even though the whole team is engaged, a single moderator still maintains control over the conversation which creates a consistent experience for the participant.

If you’re interested in creating your own backchannel, here are some tips to make the process work smoothly:

  • Use the chat tool that is already being used on the project. In most cases, we use a joint Slack workspace for the session backchannel but we’ve also used Microsoft Teams.
  • Create a dedicated channel like #moderated-sessions. Conversation in this channel should be limited to backchannel discussions during sessions. This keeps the communication consolidated and makes it easier for the moderator to stay focused during the session.
  • Keep communication limited. Channel participants should ask basic questions that are easy to consume quickly. Supplemental commentary and analysis should not take place in the dedicated channel.
  • Use emoji responses. The moderator can add a quick thumbs up to indicate that they’ve seen a question.

Introducing backchannels for communication during remote moderated sessions has been a beneficial change to our research process. It not only provides an easy way for clients to stay engaged during the data collection process but also increases the moderator’s ability to focus on the most important topics and to ask the most useful follow-up questions.




cli

CLI Equivalents for Common MAMP PRO and Sequel Pro Tasks

Working on website front ends I sometimes use MAMP PRO to manage local hosts and Sequel Pro to manage databases. Living primarily in my text editor, a terminal, and a browser window, moving to these click-heavy dedicated apps can feel clunky. Happily, the tasks I have most frequently turned to those apps for —starting and stopping servers, creating new hosts, and importing, exporting, deleting, and creating databases— can be done from the command line.

I still pull up MAMP PRO if I need to change a host's PHP version or work with its other more specialized settings, or Sequel Pro to quickly inspect a database, but for the most part I can stay on the keyboard and in my terminal. Here's how:

Command Line MAMP PRO

You can start and stop MAMP PRO's servers from the command line. You can even do this when the MAMP PRO desktop app isn't open.

Note: MAMP PRO's menu icon will not change color to reflect the running/stopped status when the status is changed via the command line.

  • Start the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd startServers
  • Stop the MAMP PRO servers:
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd stopServers
  • Create a host (replace host_name and root_path):
/Applications/MAMP PRO.app/Contents/MacOS/MAMP PRO cmd createHost host_name root_path

MAMP PRO-friendly Command Line Sequel Pro

Note: if you don't use MAMP PRO, just replace the /Applications/MAMP/Library/bin/mysql with mysql.

In all of the following commands, replace username with your user name (locally this is likely root) and database_name with your database name. The -p (password) flag with no argument will trigger an interactive password prompt. This is more secure than including your password in the command itself (like -pYourPasswordHere). Of course, if you're using the default password root is not particular secure to begin with so you might just do -pYourPasswordHere.

Setting the -h (host) flag to localhost or 127.0.0.1 tells mysql to look at what's on localhost. With the MAMP PRO servers running, that will be the MAMP PRO databases.

# with the MAMP PRO servers running, these are equivalent:
# /Applications/MAMP/Library/bin/mysql -h 127.0.0.1 other_options
# and
# /Applications/MAMP/Library/bin/mysql -h localhost other_options

/Applications/MAMP/Library/bin/mysql mysql_options # enter. opens an interactive mysql session
mysql> some command; # don't forget the semicolon
mysql> exit;
  • Create a local database
# with the MAMP PRO servers running
# replace `username` with your username, which is `root` by default
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "create database database_name"

or

# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p # and then enter
mysql> create database database_name; # don't forget the semicolon
mysql> exit

    MAMP PRO's databases are stored in /Library/Application Support/appsolute/MAMP PRO/db so to confirm that it worked you can

ls /Library/Application Support/appsolute/MAMP PRO/db
# will output the available mysql versions. For example I have
mysql56_2018-11-05_16-25-13     mysql57

# If it isn't clear which one you're after, open the main MAMP PRO and click
# on the MySQL "servers and services" item. In my case it shows "Version: 5.7.26"

# Now look in the relevant MySQL directory
ls /Library/Application Support/appsolute/MAMP PRO/db/mysql57
# the newly created database should be in the list
  • Delete a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p -e "drop database database_name"
  • Export a dump of a local database. Note that this uses mysqldump not mysql.
# to export an uncompressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name > the/output/path.sql

# to export a compressed file
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysqldump -h localhost -u username -p database_name | gzip -c > the/output/path.gz

  • Export a local dump from an external database over SSH. Note that this uses mysqldump not mysql.

# replace `ssh-user`, `ssh_host`, `mysql_user`, `database_name`, and the output path

# to end up with an uncompressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" | gunzip > the/output/path.sql

# to end up with a compressed file
ssh ssh_user@ssh_host "mysqldump -u mysql_user -p database_name | gzip -c" > the/output/path.gz
  • Import a local database dump into a local database
# with the MAMP PRO servers running
# replace `username` (`root` by default) and `database_name`
/Applications/MAMP/Library/bin/mysql -h localhost -u username -p database_name < the/dump/path.sql
  • Import a local database dump into a remote database over SSH. Use care with this one. But if you are doing it with Sequel Pro —maybe you are copying a Craft site's database from a production server to a QA server— you might as well be able to do it on the command line.
ssh ssh_user@ssh_host "mysql -u username -p remote_database_name" < the/local/dump/path.sql


For me, using the command line instead of the MAMP PRO and Sequel Pro GUI means less switching between keyboard and mouse, less opening up GUI features that aren't typically visible on my screen, and generally better DX. Give it a try! And while MAMP Pro's CLI is limited to the essentials, command line mysql of course knows no limits. If there's something else you use Sequel Pro for, you may be able to come up with a mysql CLI equivalent you like even better.



  • Code
  • Front-end Engineering
  • Back-end Engineering